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

#### Lomanator

##### New Member
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

### Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
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:
Code:
``=VLOOKUP(B1,A:A,1,0)``

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

Last edited:
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?

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.

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?

 1 A B C 2 Supplier's product codes Your product codes Lookup 3 T1700 T1802 =VLOOKUP(B3,A:A,1,0) 4 T1701 B1806 Drag down the above formula. 5 ... 6 ... 7 T1900 8 B1800 9 B1801 10 ... 11 B1900

<tbody>
</tbody>

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

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

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?
Cheers
John

Replies
1
Views
131
Replies
1
Views
947
Replies
2
Views
991
Replies
3
Views
684
Replies
0
Views
153

1,207,168
Messages
6,076,907
Members
446,239
Latest member
Home Nest

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back