Originally Posted by trebor57

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!