Reputation: 135
At work I have a list of products with a unique product code and the manufacturers name.
In a separate document I have a list of products we have in the shop floor, as well as our custom name for that product.
I want to populate the manufacturers spreadsheet with our product name by performing some form of lookup.
I've merged the two Excel spreadsheets to that I have one document, 2 sheets.
Product code format is ABC1234
.
ManSheet
ID | Manufacturer Name | Our Name
ABC1234 | Jolly | Jilly
OurSheet
ID | Our Name
ABC1234 | **=VLOOKUP(A1,'ManSheet'!A:A,2,FALSE)**
Could someone please help me with the formula.
Upvotes: 0
Views: 37
Reputation: 145
VLOOKUP First things first, you put the VLOOKUP on the sheet you wish to bring back the data to.
VLOOKUP syntax:
=VLOOKUP(Cell you wish to search,
range of cells you wish want to check,
Column on range with the value that you want to return,
Exact/Approximate match)
So on your "ManSheet" add another column:
ID | Manufacturer Name | Our Name | LookedUp Column
ABC1234 | Jolly | Jilly | =VLOOKUP(A2, Sheet2!A:B, 1, FALSE)
So your lookup should be something along the lines of this, you can then drag this cell down to populate the rows below and do a mass vlookup:
=VLOOKUP(A4, ManSheet!A:B, 2, FALSE)
Upvotes: 1