View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EZ[_2_] EZ[_2_] is offline
external usenet poster
 
Posts: 21
Default Index Match Error


Here's my formula:
INDEX(List,MATCH(AM2,Time,0),MATCH(AO2,Class,0),MA TCH(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.
--
when u change the way u look @ things, the things u look at change.