Really challenging lookup situation.
 

Hello every one,
I got this really challenging lookup situation.
First this is sample table layout:
__A____B__C____D___E_____F____G__
_________1ST__2ND__3RD__2ND__1ST_
name1__________X_________X________
name2_____X______________X_____X__
name3__1__X_________X__________X__
name4_______X_________X____X______
name5__1__X_________X__________X__
name6____________X_________X______
name7__1__X_________X____X________
name8____________X____X___________
name9__1____X______________X______
I want formula which will return list of names from col. A, if there is no
number in col.B and there is €œX€� in 1ST or 2nd col(s)., but ignore 3rd col.
Please help me I am losing sleep over this one.
I do understand that this is calling for multicell array formula, and I also
dont want to create any additional columns to achieve desired result.
Thank you,
Guntars

Really challenging lookup situation.
 

hope I didn't miss anything
would:

=IF(AND(NOT(ISNUMBER(B1)),OR(C1="x",D1="x")),"yes" ,"no")

help?


On 1 Cze, 05:37, Guntars wrote:
Hello every one,
I got this really challenging lookup situation.
First this is sample table layout:
__A____B__C____D___E_____F____G__
_________1ST__2ND__3RD__2ND__1ST_
name1__________X_________X________
name2_____X______________X_____X__ * * * * * * *
name3__1__X_________X__________X__
name4_______X_________X____X______ * * * * * * *
name5__1__X_________X__________X__
name6____________X_________X______
name7__1__X_________X____X________
name8____________X____X___________
name9__1____X______________X______
I want formula which will return list of names from col. A, if there is no
number in col.B and there is “X” in 1ST or 2nd col(s)., but ignore 3rd col.
Please help me I am losing sleep over this one.
I do understand that this is calling for multicell array formula, and I also
don’t want to create any additional columns to achieve desired result.
Thank you,
Guntars