Dabbling with an area of excel that I don't normally do but if I can make this work it will save me loads of time.
Basically we have a list of parts we have to deliver every week, the requirements can be downloaded in CSV so I can then paste them into my sheet. What I want is for the sheet to then put our internal works order number against each of our customers part numbers.
So
AB1243
BA3845
Will return in the column next to it (where the W number is our internal works order)
AB1234 W00001
BA3845 W00345
I've put a list of Part numbers in a column A on sheet 2 with there corresponding Works order next to each part number on Column B on sheet 2 and tried below (where d1 is the cell with the part number)
=VLOOKUP(D1,Sheet2!A2:A31,Sheet2!B:B)
and this doesn't work, can't for the life of me make it fly, what am I missing or do I need to attack this a different way?
/edit just tried =VLOOKUP(D1,Sheet2!A2:A31,2) after a bit of reading around and that doesn't work ether (#ref error)
Basically we have a list of parts we have to deliver every week, the requirements can be downloaded in CSV so I can then paste them into my sheet. What I want is for the sheet to then put our internal works order number against each of our customers part numbers.
So
AB1243
BA3845
Will return in the column next to it (where the W number is our internal works order)
AB1234 W00001
BA3845 W00345
I've put a list of Part numbers in a column A on sheet 2 with there corresponding Works order next to each part number on Column B on sheet 2 and tried below (where d1 is the cell with the part number)
=VLOOKUP(D1,Sheet2!A2:A31,Sheet2!B:B)
and this doesn't work, can't for the life of me make it fly, what am I missing or do I need to attack this a different way?
/edit just tried =VLOOKUP(D1,Sheet2!A2:A31,2) after a bit of reading around and that doesn't work ether (#ref error)
Last edited: