hi i am using following function in cell to get value. it seems quit
complicated. i was wondering does anyone know, how i can convert thi
statement to vba, using select case exaple. i am getting an error, wit
find and error statement, also dim cell getting #value or 0. not th
answer! will apprecaite it.

thanks

=IF(ISERROR(FIND("Voy",C2)), IF(ISERROR(FIND("ENC",C2))
IF(ISERROR(FIND("CS",C2)), IF(ISERROR(FIND("LFP",C2))
IF(ISERROR(FIND("ARS",C2)), IF(ISERROR(FIND("ERA",C2))
IF(ISERROR(FIND("3M",C2)), IF(ISERROR(FIND("EDC",C2))
IF(ISERROR(FIND("Test Server",C2)), IF(ISERROR(FIND("Media",C2))
IF(ISERROR(FIND("ub",C2))
IF(ISERROR(FIND("uc",C2)),0,”UC”),”UB”),”Media Scheduling”),”Tes
Server”),”EDC”),”3MSC”),”ERA”),”ARS”),”LF+”),”Cita tio
Server”),”ENC”),”Voyager”

--
Message posted from http://www.ExcelForum.com