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." wrote:

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!