MrExcel Publishing
Your One Stop for Excel Tips & Solutions

NEED A FORMULA


Posted by MARTHA on October 06, 2001 9:28 AM

I want to look at a large list of codes. Some codes can be listed two different ways, but I want to be constant on one code. Currently I am using an IF statement: =IF(B3="FMY","RSW","")&IF(B3="YTO","YYZ".. (20different codes). Does anyone know a simpilar formula such as If(b3=("fmy","rsw"("yto","yyz...ect


Posted by Aladin Akyurek on October 06, 2001 11:20 AM

Martha,

Not sure I understand your question and what you want to accomplish.
Care to elaborate?

Aladin

============