Hi,

=VLOOKUP(A1,Sheet2!B1:D1000,2,FALSE)

where A1 is the product code, and on sheet2 the product codes are in column
B and the info you want back is in column C. Since B is 1, C is 2 here.
False means you want an exact match only.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Dave" wrote:

Here is what I would like a formula to do???

I have two workbooks- I will place the formula only in one and extract
data/info. from the other.

What I want the formula to do is...
I want it to search through a column of product codes from the other
workbook (numbers, e.g. 21, 22) and when the desired code (let's say 21) is
detected. I want it to return the information (text info) from a different
column (I.E. transaction description) but the same row as the desired result
(21).

I have been messing with Vlookups and have had no luck. I'm thinking I
might need a nested if formula???

Any help would be awesome.