I am using the following formula and if there is more than 8, it gives me an error msg each time (and I am sure to add additional )'s at the end. Any suggestions how I could get it to allow as many as I want. Thanks in advance.

=IF(F5="1K","51126",IF(F5="2AC","36320",IF(F5="0AP","49003",IF(F5="3AC","36316",IF(F5="9CH","45284",IF(F5="1DB","318",IF(F5="6AC","53570",IF(F5="149","1045",""))))))))

I am wanting to be able to put as many as I want. Thanks in advance. Mcr1