More Excel help here please.

Soldato
Joined
18 Oct 2002
Posts
3,714
Location
Sussex
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)
 
Last edited:
Try this but its always hard to know what someone actually needs when just typing the problem on the forum:

=VLOOKUP(D1,Sheet2!A:B,2,0)
 
Thanks Dazzerd, I know its hard to describe the problem I was having, screen dumps were next!
Sussed it this morning though.
=VLOOKUP(D1,Sheet2!A2:B31,2)

It was the B31, what I didn't twig was that the reference A2:B31 should cover the whole of the lookup table and not just the column that contained the data to search against. Anyway, its working now :)
 
Back
Top Bottom