E
EZ
Here's my formula:
INDEX(List,MATCH(AM2,Time,0),MATCH(AO2,Class,0),MATCH(AP2,Size,0))
My ranges are in another data sheet.
List ($C$2:$CN$56)
Time($C$1:$CN$1)
Class($A$2:$A$56)
Size($B$2:$B$56)
The formula brings in the correct data for the first row which's in C2 of
the List range, but once I copy my formula down instead of returning vlaues
in D2, E2, F2, etc it keeps going down the column and brings in C3, C4, C5,
etc. What do I need to do to make the formula works correctly (I'm looking up
two columns and a one row?
Thanks.
INDEX(List,MATCH(AM2,Time,0),MATCH(AO2,Class,0),MATCH(AP2,Size,0))
My ranges are in another data sheet.
List ($C$2:$CN$56)
Time($C$1:$CN$1)
Class($A$2:$A$56)
Size($B$2:$B$56)
The formula brings in the correct data for the first row which's in C2 of
the List range, but once I copy my formula down instead of returning vlaues
in D2, E2, F2, etc it keeps going down the column and brings in C3, C4, C5,
etc. What do I need to do to make the formula works correctly (I'm looking up
two columns and a one row?
Thanks.