I have workbooks one per year with codes in Column N and Categories in
O.

The codes and data vary from year to year so a code i.e. AKC for the
Category Graphic Design may appear in 2005 but not in 2006.

I have created a master list of Codes which I have in a seperate
workbook in Column L.

I tried using Vlookup on 2005 alone but then I get #N/A where the code
isn't in the year, so I tried combing ISNA with Vlookup which works for
one year but then I have 5 columns of categories one for each year
2005-2009, and I have to cut and paste as vales to create one single
column of catagories that match the adjacent codes.

The categories won't change new codes and categories will be added and
I have to make provision for 400 codes.

Is there an easier way to do this?


--
Timbo
------------------------------------------------------------------------
Timbo's Profile: http://www.thecodecage.com/forumz/member.php?userid=24
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=95268