need to work across two sheets in excel 2003
 

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)

need to work across two sheets in 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))

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

need to work across two sheets in excel 2003
 

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

--
Regards
Roger Govier

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
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)

need to work across two sheets in excel 2003
 

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

"Roger Govier" wrote:

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

--
Regards
Roger Govier

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
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)