ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   getting data from a table (https://www.excelbanter.com/excel-worksheet-functions/268460-getting-data-table.html)

trebor57

getting data from a table
 
heres my issue:
I have a table, (AA3:AJ33), row (3) each column contains "diffrent voltages". In column (AA) each row contains "diffrent motor sizes". in the table (AB4:AJ33) is the amperage required for each motor/voltage combination. cell (AA3) containg "HP".

Heres what I am looking for, I want to enter in in cell (F4) the motor size thats in column (AA4:AA33) then, in cell (J6) the voltage thats in row (AB3:AJ3) and have the intersecting cell value returned to cell (L4).

the data in the cells (AA3:AJ33) is static and will not change. the values inputted into (F4) will always match data column (AA) and the values inputted into (J6) will always match the data in row (3)

HELLLP!


All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com