I have a massive spreadsheet of ebay sales 30,000+ Rows and 20+ columns. Half of the sales are mine, Half are sales of a business partner. I am hoping to get some help from a guru to label these.
The idea of how it would work....
Sheet1 has a Column B with Item numbers of sold items (item numbers have many duplicates some not)
Sheet2 has Column A with item numbers, Column B with the labels that I want to pull over to sheet 1. (The Item Numbers are a unique number set)
One other issue or concern, Not all rows have a item number in the item number Column... So the formula could leave this blank or label as none)
If needed I could potentially do this in access but have very little knowledge.
Thank you in advance! I assume this has been answered before but I do not know how to search for it, If anyone knows a formula need to look up as well
I have attached a very simple version xls file to demonstrate.
Bookmarks