| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
reference data in 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! |
|
#2
|
|||
|
|||
Quote:
Dear Trebor57, good morning. Please, save your worksheet in a free site, Ex.: www.4shared.com, and put the link here. It will be very quick and easy to help you to solve your question. I hope hear from you soon.
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what does "data source reference is not valid' in Pivot table | New Users to Excel | |||
| How can I change the source data reference to another pivot table? | Excel Discussion (Misc queries) | |||
| Cross Reference Table Data Searching | Excel Worksheet Functions | |||
| Copy data from pivot table using relative reference | Excel Discussion (Misc queries) | |||
| Define and Reference fixed data in a table | New Users to Excel | |||
Hybrid Mode
