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


--
mcr1
------------------------------------------------------------------------
mcr1's Profile: http://www.excelforum.com/member.php...o&userid=15496
View this thread: http://www.excelforum.com/showthread...hreadid=498860