Website CVS help....

[Alex Caldecott]

Hello!

Sorry if I fail to explain this very well....

Basically I have two spread sheets, one is an export from our website showing a list of 5715 product codes from a certain supplier, the other is an export from the supplier showing a list of their full range 9112 products with prices.

I have two tasks I need to complete:

First one is transferring the prices from the suppliers full list over to our smaller list, I'm assuming there is a way to do this by matching up the product codes and transferring the prices over for just the items in our list?

Second one is highlighting the products in the bigger list that are missing from our smaller list so that I know what products we are missing from our site and need to get added?

Any help would be greatly appreciated!

Cheers, Alex.

 

[Trevor G]

Hi Alex, are you downloading them into the same workbook and on separate sheets? If yes then you could use a Vlookup to identify the product code to give you the price of the items.

The second question you'd be looking at using conditional formatting to identify whats missing from your list.

 

[hayden]

The first one can be done with a lookup formula. Index and mach, vlookup, or xlookup.

I like index and match the best

=index(range of prices from the big list),match(product code from small list, range of product codes from big list,0))

The ,0 part is important. It means you only want to match exact matches of the product code.

 

[Alex Caldecott]

Thanks for the replies! I used VLOOKUP and got it working

 

[Trevor G]

Pleased to read you've found a solution that works for you. Thanks for letting us know.