Posted to microsoft.public.excel.misc
|
|
Multiple Ifs, can't use vlookup
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):
=IF(COUNTA(A2:I2),CHOOSE(MATCH(FALSE,ISBLANK(A2:I2 ),FALSE),
"SFO","NY","LA","DC","UT","WA","HI","JP","CH"),"ex cluded")
In article . com,
wrote:
Thanks it works great.
My another question is that my boss want me to show location instead of
A through I.
Like
=IF((A2<""),"SFO",IF((b2<""),"NY",IF((c2<""),"L A",IF((d2<""),"DC",if((e2<
""),"
UT",if((f2<""),"WA",If((g2<""),"HI",if((h<"")," JP",
if((i2<""),"CH","excluded")))))))))
Can you help me with it?
|