Really challenging lookup situation.

G

Guntars

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
 
J

Jarek Kujawa

hope I didn't miss anything
would:

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

help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup help needed 1
Look Up challenge 3
Two search arguments in array formula 2
Function or Sub to help with text string 5
How to retrieve Named Range name? 2
Challenging SUMING situation! 6
How do I count cells with specific value? 5
Looking for a solution 1

Top