Is this possible? How? 2 sheets/2 variables

I have column A with product code numbers on it and column B with price on one sheet 1.

On sheet 2, i have column A with the product codes (not in the same order as sheet 1) and on column B the quantity available in stock.

I would like to evaluate my stock, so i would like for Column C in sheet 2 to go get the price (column B in sheet 1) according to the product code number (column 1). Keep in mind column A in the two sheets are not in the same order.

Thanks so much for your help.

Take a look at this link on VLOOKUP

http://www.contextures.com/xlFunctions02.html

Did you mean to use VLOOKUP? (Not just LOOKUP). If you're trying to return the value from column B of sheet1 into column C of sheet 2, then use VLOOKUP.

Try this in C2 of Sheet2 (and fill down as many rows as necessary):

=VLOOKUP(A2,Sheet1!$A$2:$B$20,2)

This formula will look up the value of A2 (Sheet2) in Sheet1!A2:B20. The final "2" tells it to retrieve the value in the "2"nd column of your search range (A2:B20).

*** Column A on Sheet1 should be in ascending order for this to work, if I'm not mistaken, otherwise the VLOOKUP formula could fail.

*** The $'s in the VLOOKUP formula will ensure that as you fill the formula down many rows, the lookup range will not change.

If you'd like, post your spreadsheet (with demo data if you have privacy concerns) and i'll take a look.

I tested the formula on a sheet I just put together and it works just fine.

Thanks.

To post a zipped example here, go to “My Documents” or wherever you have your file stored, right-click and “Send to > Compressed file”, then attach this to your post