View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
George George is offline
external usenet poster
 
Posts: 347
Default Using index and match

Hi all-
Im, trying to use an index and match function to return text from cells on
anther sheet. =INDEX(Formulas!$J$3:$K$6,MATCH(AM7,Formulas!$J$3: $K$6)) The
formula looks for a value that matches AM7, it is suppose to return text from
cells on another page shown below. I keep getting the dreaded #n/a. I have
the text organized in cells

Clmn J Clmn K

Row 3 4.0 This was out-standing
Row 4 2.8 Pretty good but you need ot work on
Row 5 1.5 You really need to focus on this more
0.0 No comment here


Anyhelp would be very appraciated
Cheers
George