Excel 2007 : IF Statement Help

[Rino468]

Hello All !!!

I have to create a spreadsheet that basically shows an employee's department and their supervisor.

So basically

Accounting boss is - Weinberg
Customer Service boss - Jones
Human Resource boss is Patterson...

so and so forth ...

So to put it simply I basically want:

A=1
B=2
C=3
D=4


There are 26 departments in my company.
This is what I am thinking about using

=IF(B4="A","1",IF(B4="B","2",IF(B4="C","3",IF(B4="D","4",))))

Is there an easier way to do it? Or do I have to IF 26 times?

Thanks ahead of time.

[TMS]

You could use VLOOKUP or INDEX/MATCH with a pre-defined table, or you could use CHOOSE to select from a list.

If B4 contains A, whatever,

Please Login or Register  to view this content.

would return 1

Regards

[outofthehat]

For more detail on using VLOOKUP for this task, look here:
Categorising data with VLOOKUP