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
|