Excel I'm working in 2 different workbooks and matching product codes for my website

[Lomanator]

Hey Guys and Gals,

I am trying to do a bulk upload of products to my website, the suppliers have sent me the entire product range as a CSV, but I only stock a fraction of the products.
What I want to do is to copy and paste all the information from them in to my workbook which I have exported from my epos system.
Lets say I have 200 products and they have sent me a workbook with 2000, how to I get there list down to the 200 products I have?
Hope that makes sense.

Cheers
John

 

[Exceladd1ct]

If the products have the same name on both (yours and their) workbooks, you can use VLOOKUP function:
Suppose Column A is filled with your suppliers 2000 products. (Starting from A1)
Column B is filled with yours 200 products. (Starting from B1)
In C1 use this formula and copy down:

=VLOOKUP(B1,A:A,1,0)

PS: All above columns should be in the same workbook.

 

[Lomanator]

Thanks for coming back to me, the only thing that is the same is the Supplier product code for instance B9504, can you do a VLOOKUP with a mixture of letters and numbers?

 

[Exceladd1ct]

VLOOKUP Exact match method works with any kind of values as long as they are identical. Just change the cell range accordingly and give it a try.

 

[Lomanator]

Thanks, so i'm looking how to do that and struggling to make it work. Lets Say I have my product code T1802 and B1806 And the suppliers have T1700 to T1900 and also B1800 to B1900, how do I make the formula work to find my products in the suppliers list?
thanks for all your help

 

[Exceladd1ct]

[TABLE="class: grid, width: 150, align: left"]
<tbody>[TR]
[TD]1
[/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Supplier's product codes
[/TD]
[TD]Your product codes
[/TD]
[TD]Lookup
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]T1700
[/TD]
[TD]T1802
[/TD]
[TD]=VLOOKUP(B3,A:A,1,0)
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]T1701
[/TD]
[TD]B1806
[/TD]
[TD]Drag down the above formula.
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]...
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]...
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]T1900
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]B1800
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]B1801
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]...
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]B1900
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]





















Give it a try and let me know if it works.

 

[Lomanator]

OMG its worked, I can now sort the products they have and I have so I can copy and paste all of my product descriptions in to my CSV in 1 hit.
Thanks so much I will eternally grateful
Cheers
John

 

[Lomanator]

Hi guys, so I'm looking at this again and have forgotten how to do it and can't get it to work.
I have say 10 products in my shop and I want to get the descriptions of my suppliers csv file and copy and paste them in to my workbook.
if have added a sheet with my products in to the suppliers workbook, how do I match up the suppliers products so I can literally copy and paste them to match mine?
thanks for your help
Cheers
John