Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|