Index Match Error

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top