Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vLookup with multiple lookup value in table array | Excel Worksheet Functions | |||
Want Vlookup to list multiple items with the same key? | Excel Worksheet Functions | |||
vLookup - display multiple rows | Excel Worksheet Functions | |||
Using VLOOKUP with multiple first column matches | Excel Worksheet Functions | |||
Multiple Vlookup? | Excel Worksheet Functions |