Log In
Register
Home
New Member
May 13, 2020
Offline
I'm sure this is very simple, but I am stumped - I have a spreadsheet with 40,000 lines of individual sales data over 2 years. Each line references a part number, and I have set up Pivot Table reports to break down sales data by rep, territory, etc. However, as I have 500+ part numbers, I need a description field to make the data useful. I have a master list of part numbers with corresponding descriptions, but cannot figure out the proper way to have Excel look up the part number and plug the corresponding description into the adjacent column. This is a small pull of some of the field. I'm sure this is very easy, but I cannot for the life of me figure out how to do it!
Thanks in advance!
| Cust. Name | Part No. | Description | Order date | Ord. Qty | Retail price |
| ACCTEST INDUSTRIAL CLEANING CHEMICALS | BP2933WB | 2017-12-01 | 324 | $5.71 | |
| ACCTEST INDUSTRIAL CLEANING CHEMICALS | BP4593WB | 2017-12-01 | 360 | $2.99 | |
| ACCTEST INDUSTRIAL CLEANING CHEMICALS | BM2453 | 2017-12-01 | 108 | $6.30 | |
| ACCTEST INDUSTRIAL CLEANING CHEMICALS | BM2173 | 2017-12-01 | 108 | $2.48 | |
| AZ PROFESSIONAL HAIR PRODUCTS LTD | GP0601 | 2017-12-01 | 500 | $13.45 | |
| TOTAL CUSTOM PACKAGING | MO0055 | 2017-12-01 | 5,226 | $2.49 | |
| EMTEST | GP0741 | 2017-11-30 | 75 | $18.48 |
VIP
April 21, 2015
Offline
Welcome to Mynda's Forum Blake!
As I understand your explanation, you have to use the Vlookup in this Description field.
It's better when you supply a sample Excelsheet, but I give it a try.
Let's say your other data has the part no in column A and the description in column B (the second column of that data table).
The Vlookup you have to use says: =Vlookup(B2,table where it has to look,2,0).
B2 assuming the field 'Cust.Name' is in A1.
Hope this helps?
Frans
1 Guest(s)
