View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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?