Adding descriptions to product codes

**paulboy** · 04-18-2009, 03:33 AM

Hi,
Although I use excel on a regular basis I am by no means an expert but I can do enough to get by at work and create usable and useful spreadsheets.
Currently at work I am creating several core lists of items that are used in specific operations (I work in a hospital). I have a master list which shows the product code and the description of the item but so far on the core lists I only have the product code without a description. As there are about 1000 lines on the master list I would prefer not to have to trawl through it to copy and paste to the core lists. Is there a macro or something that will automate this and if so how do I set it up?
I hope someone can help! Thanks in advance.
Paul.

**DonkeyOte** · 04-18-2009, 03:37 AM

Could you perhaps use VLOOKUP ?

Consider:
Core List A1 holds Product Code, you want Description in B1:
Master List is held in Columns A (Product) & B (Description) on sheet called MASTER.

B1: =VLOOKUP($A1,Master!$A:$B,2,0)

See XL Help for more info if this is viable approach for you.