Do I use VLookup? or .........what?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having a hard time trying to use the "Vlookup" or "If" functions. I have a two spreadsheets with a common column (Product SKU), although one of the columns has been recently updated. I'm trying to carry over a second column that specifies "jars per minute"(JPM). Each JPM is identified by a "Product SKU". There is about 5,000 SKU's, and i'm trying to find a way to carry over information without having to do it manually. I tried the VLookUp and If functions, but I'm not even sure if its the right method.

Please help!!!
 
Hi
VLOOKUP seems to be the right choice. See
http://www.mvps.org/dmcritchie/excel/vlookup.htm
for instructions how to use it.

in your case lets make the following assumptions:
- You have two sheets: sheet1 and sheet2
- in sheet1 you have the Product SKU (in col. A) and the 'JPM' (in col.
B)
- on sheet2 you only have the Poduct SKU (also in col. A)

Now use the following formula in B1 of your second sheet to get the
correct JPM from sheet1:
=VLOOKUP(a1,'sheet1'!$A$!:$B$6000,2,0)
and copy down
 
Back
Top