Create a lookup table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of 1,000+ names and addressess in one spreadsheet. Each name
has five or six numeric codes associated with it, all in a single cell
separated by /. In a separate sheet I have a list of the codes with each one
referring to a text field next to it containg a job title.

I want to search the list of names to look-up the code and then put the
correct job title into a new column. Some names might have more than one code.
 
Hi
and what should happen for those that have more than one
code. How do you want the ooutput displayed (maybe you can
also post some example rows of data - plain text please)
 
The names data looks like this (with the codes in the final column):

L0204 Councillor Ray L Oliver Councillor Oliver Deputy Leader of the Labour
Group Bedford Borough Council 4 Loveridge Avenue Kempston BEDFORD MK42
8SD 01234-856781 01234-303029 /414/508/260/199/
L0205 Cllr Mrs Liz Ledster Cllr Mrs Ledster Deputy Leader of the Liberal
Democrat Group South Bedfordshire District Council 21 Harlington
Road Sundon LUTON LU3 3PE 01525-873131 01525-875784 /415/662/260/199/

The lookup/key code data looks like this:

code group category
470 CABINET MEMBERS Equal Opps/Womens Rights Cabinet Mbr
480 CABINET MEMBERS Personnel Cabinet Member
498 EXECUTIVE COMMITTEE CHAIRS/CONVENERS Equal Opps/women's Rights Chairman
508 EXECUTIVE COMMITTEE CHAIRS/CONVENERS Personnel Chairman

I want to put the job title such as Personnel Chairman with any of the names
that have that key code. As it is possible to have more than one job if there
is more than one code I want both job titles.

Thanks.
 
Back
Top