need to work across two sheets in excel 2003

  • Thread starter Thread starter Vandy
  • Start date Start date
V

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)
 
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))
 
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))
 
Thank You....it works.. Have a great day!

Roger Govier said:
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))
Click to expand...
 
Back
Top