Help with IF Function !!

[gprogers]

Trying to setup following function:

=IF(C4="AC","1",IF(C4="LAC","2",IF(C4="CPL","3",IF(C4="SGT","4",IF(C4="FSGT","5",IF(C4="WOFF","6",IF(C4="FLGOFF","7",IF(C4="FLTLT","8",IF(C4="SQNLDR","9",IF(C4="WGCDR","10",IF(C4="ACW","1",IF(C4="LACW","2","")))

Basically want values in cell C4 to trigger a number to be allocated in C2 depending on the rank.

Coming up with error....need help.

 

[Michael M]

Ahh, I think the problem has to do with the fact that the numbers aren't ascending, the last 2 should be 11,12.
So, try this instead.

=IF(C4="","",CHOOSE(MATCH(C4,{"AC","LAC","CPL","SGT","FSGT","WOFF","FLGOFF","FLTLT","SQNLDR","WGCDR","ACW","LACW"},0),1,2,3,4,5,6,7,8,9,10,1,2))

my apologies for the error.

 

[gprogers]

terrific - thanks again mate. worked like a gem