Formula for associating roles with names

B

bam

I have a defect database with a list of people's names, defect numbers, date
entered, etc, which I have imported into excel. There is a finite number of
names that appear multiple times in column A. I woud like to create a second
column that automatically associates a role with a name. For example, for
every instance of "Mike" in column A, I'd like column B to display
"Developer." For every instance of the name "Bill" in column A I would like
to display the role "QA." I can create a separate table with mappings of
names to roles for all the names that appear in column A.

Any help appreciated,

Thanks in advance

bmac
 
P

Peo Sjoblom

Look up VLOOKUP in help

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
R

RagDyeR

A simple Vlookup() formula would do what you're looking for.

Say your table of mappings was located in Y1 to Z25, with the names in
Column Y and the roles in Column Z.

Enter this formula in B1 and copy down as needed:

=VLOOKUP(A1,$Y$1:$Z$25,2,0)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I have a defect database with a list of people's names, defect numbers, date
entered, etc, which I have imported into excel. There is a finite number of
names that appear multiple times in column A. I woud like to create a second
column that automatically associates a role with a name. For example, for
every instance of "Mike" in column A, I'd like column B to display
"Developer." For every instance of the name "Bill" in column A I would like
to display the role "QA." I can create a separate table with mappings of
names to roles for all the names that appear in column A.

Any help appreciated,

Thanks in advance

bmac
 
Top