Excel 2003 Formula Help

[Kilsharion]

I think this would be possible, but I'm stumbling in trying to figur
out how to manage it.

Here's what I have...I want to take sheet X and have the formula i
column F. I want it to look at the corresponding cell in column
(i.e. A2) then search sheet A column D for a match. If it finds
match, I want it to return the value that is in sheet A column A of th
corresponding cell (i.e. it finds it on sheetA!D54 and returns th
value entered in sheetA!A54).

Is this possible? Or am I having pipe dreams?

Thanks!
Kilsharion

:confused

 

[Bob Phillips]

Kilsharion,

This might do it, in SheetX F2

=INDEX(SheetA!A:A, MATCH(SheetA!D,A2,0),1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi
normaly you would use VLOOKUP. eg. you would enter the following in F2:
=VLOOKUP(A2,'Sheet A'!$A$1$$9999,2,False)

Though the problem in your example is that VLOOKUP only searches the
first column of a matrix. But you want to search the 4th column. So
unless you are not able to change your table layout you have to use a
different approach with INDEX and MATCH
=INDEX('Sheet A'!$A$1:$D$9999,MATCH(A2,'Sheet A'!$D$1:$D$9999,0),1)

you can copy this formula for all other rows

HTH
Frank