Try this...

=INDEX(Formulas!$K$3:$K$6,MATCH(AM7,Formulas!$J$3: $J$6, false))
--
HTH...

Jim Thomlinson


"george" wrote:

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