Hi Vandy

In B4 enter
=INDEX(Sheet2!$A:$A,MATCH(Sheet2!$C:$C,"AC",0))
better still would be if your Value AC was entered in A4, then substitute
that in the formula

=INDEX(Sheet2!$A:$A,MATCH(Sheet2!$C:$C,A4,0))

--
Regards
Roger Govier

"Vandy" wrote in message
...
I need to be able to put in column b4 on sheet 1 the answer to this, on
sheet
2 find "AC" in column C and put the corresponding name in column A, in b4
on
sheet 1. (excel 2003)