| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I detail Pivot Table data without creating a table (Excel2007) | Excel Discussion (Misc queries) | |||
| How can I detail Pivot Table data without creating a table (Excel2007) | Excel Discussion (Misc queries) | |||
| View Pivot Table Source data as a Data Table | Excel Discussion (Misc queries) | |||
| Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
| Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) | |||
Linear Mode
