easier way to assign code to cell values

[nikegeo]

Hi all,

im wondering if there is an easier way to assign a "code" that references another cell based on its value:

I would like to assign the numbers 1-5 in column b for the following values (respectively): pitch won (1), pitch lost(2), pending (3), pitching (4), prospecting (5)

the formula i have now which does the job is:
=IF(AND(I2="Pitch Won"),"01",IF(AND(I2="Pitch Lost"),"02",IF(I2="Pending","03",IF(I2="Pitching","04",IF(I2="Prospecting","05","")))))

wondering if theres an simpler formula to do this (fyi - i paste data into a template that has these types of formulas & calculations)

 

[Jonmo1]

Try

=MATCH(I2,{"Pitch Won","Pitch Lost","Pending","Pitching","Prospecting"},0)

 

[nikegeo]

wow thanks! much easier to look but my Match function experience is non-existent. Will surely read up on it!

Thank you for your quick response

 

[Rick Rothstein]

EDIT NOTE
==========
In rereading your question, it seems I gave you the wrong answer (mine goes from number to text whereas I now see you wanted to go from text to a number).

Another possibility...

=CHOOSE(I2,"Pitch Won","Pitch Lost","Pending","Pitching","Prospecting")

 

[nikegeo]

You're right - I tried with other data and didnt get the result i was looking for in my template...