need to work across two sheets in excel 2003

[Vandy]

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)

 

[Roger Govier]

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))

 

[Roger Govier]

Sorry Vandy, typed that incorrectly
It should read

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

 

[Vandy]

Thank You....it works.. Have a great day!

Sorry Vandy, typed that incorrectly
It should read

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