Job ID Qualifiers attached to names

  • Thread starter Thread starter paradox80
  • Start date Start date
P

paradox80

Hello everyone. great board here. I have learned a lot by lurking for
the past few months so thanks!

I am unable to solve the following problem. When I print out a report
of employees and their time, there is no Job ID related to their names.
I am trying to insert a column and write a formula that will look at a
"Job ID template" worksheet and automatically match the person's name
with their Job ID. (There are 22 employees)

I have tried nesting IF formulas, but only get about 8 of them in there
before I get an error. (This is going one at a time to make sure they
are entered correctly.) Is there a limit to 8 nested IF statements per
formula?

Next I tried nesting 8 IF statements and then adding on more with a +
=If(c2="Allen","Principle",IF(c2="Jones","CAD
Tech",IF(....,False)+IF(c2="Smith"........

To no avail.

I have also messed around with a VLOOKUP formula, but am not sure how I
would implement that in this situation.

I am really at a loss here as to how I can automate this matching
exercise and appreciate your wisdom.
Thanks in advance.
Patrick
 
Hi Patrick,

You are quite right in that there is a limit in nesting IF formulas.
VLOOKUP is the way to go.

With the following data in A1:B3
A B
1 Allen Principle
2 Jones CAD Tech
3 Smith Support

Enter "Jones" in C1 (without the quotes)
Enter in D1
=VLOOKUP(C1,A1:B3,2)

Then try Allen and Smith in C2 and you'll see how VLOOKUP works.

HTH
Anders Silvén
 
Back
Top