Highlight values equal to a list

[yuvalshabt]

Hi,

I have a list of sku's that I always edit and add more and I have a fixed list of sku's in another sheet.
The first list is my inventory and the second list is sku's specific price that I have to use.

How can I "run a scan" on the first list of the second list sku's and if a sku matches then write the price in a cell?
example:
list one:
sku 1
sku 2
sku 3


list 2:
sku 2 price - 10


result on list one:
sku 1
sku 2 price 10
sku 3


Hope I made it clear.
Thanks!!!

 

[Trebor76]

Hi yuvalshabt,

A VLOOKUP formula should suffice. If the first list of sku's are in column A (from row 2) and the second list is in Sheet2, put the following formula in cell B2 of the first sheet and copy down as far as needed:

=IFERROR(VLOOKUP(A2,Sheet2!A:B,2,FALSE),"")

You may have to change the references to suit your layout.

HTH

Robert

 

[yuvalshabt]

Hi Robert,

Thank you.

For some reason it doesn't a price, just a blank like in the formula: " ".
it works if I lookup column 1 but doesn't work for the rest - I need column 4 in the second sheet (which is the price)

Any advise?
I couldn't figure out the reason it won't work...

Thanks!

 

[Trebor76]

It returns "" when there's no match instead of showing an #N/A error. If the price is in column D of Sheet2 you'd use this:

=IFERROR(VLOOKUP(A2,Sheet2!A:D,4,FALSE),"")

If this still does not work I'll need to see the data to possibly provide a solution. Though MrExcel doesn't enable attachments, you can use a file sharing service like www.box.com for us to see your workbook.

Thanks,

Robert