Look up one value and return multiple corresponding values

[Eric S.]

Hi
I have a VLOOKUP set up to lookup value "1" contained in workbook "A" in
workbook "B". I do however also need to return a corresponding value from
workbook "B".

Suggestions?
thanks!

 

[Toppers]

What's your VLOOKUP formula (as this is used to return a crresponding value)?

=VLOOKUP(A2,Sheet2!A:B,2,0)

will return vlaue from column B on sheet2 where A2 (say sheet1) matches
column A on sheet2. The 2 indicates return the second element (column B) in
the range.

HTH

 

[Eric S.]

thanks for the fast response!
The VLOOKUP I use is:
=VLOOKUP(B2,'[BCS GWE ES RESULTS.xls]true'!$A$2:$A$1368,1,FALSE)

I noticed that when I change the "1" to "27" (column AA on the BCS GWE ES
RESULTS.xls) I get a #REF! when there is a match....

 

[Toppers]

=VLOOKUP(B2,'[BCS GWE ES RESULTS.xls]true'!$A$2:$AA$1368,27,FALSE)

should work

thanks for the fast response!
The VLOOKUP I use is:
=VLOOKUP(B2,'[BCS GWE ES RESULTS.xls]true'!$A$2:$A$1368,1,FALSE)

I noticed that when I change the "1" to "27" (column AA on the BCS GWE ES
RESULTS.xls) I get a #REF! when there is a match....

What's your VLOOKUP formula (as this is used to return a crresponding value)?

=VLOOKUP(A2,Sheet2!A:B,2,0)

will return vlaue from column B on sheet2 where A2 (say sheet1) matches
column A on sheet2. The 2 indicates return the second element (column B) in
the range.

HTH