Exclusive Lookup to match Rowwise data and give the Column Heading..

That definitely helps ..

However is there a solution without using Arrays?

Like some kind of SUMPRODUCT as this is one function which always comes up with Multiple Solutions?

Originally Posted by NBVC

Please describe the logic, generally.

Why would G3 pick up column C instead of column B or F?, etc.

We are looking for Exclusive Matches based on the "YES" in the columns..

Like if there are "Yes in all the three cells then Col F would be an Ideal Choice.

Therefore the choice would be in relation with the Yes

Originally Posted by contaminated

Hi
try this one

=INDEX($A$1:$G$1,MODE(IF(($G$2:$G$4="yes")*($B$2:$F$4="x"),COLUMN($B$1:$F$4))))

Can something be worked to get an Empty Column when there are no "Yes's " mentioned?

Dear Contaminated,

This works really well for the condition mentioned in my original query however I did not realise that it would be important to get the Blank Option too as this is a concept to validate a set of options if there are no options clicked "yes" then it should be the Blank Option but I want to somehow avoid doing it as default in case of a false condtion to your coding ..

So please help me on this tooo!

Dear Contaminated,

Let me try and get back to you..

Thanks a lot for the workaround...

Hi Contaminated,

Thanks a lot, This definitely works and can u please explain the code I think I will have to keep the false part as the default blank option..

The First Column would be blank so incase of no option selected I will force it to display Col A which is not showing in the file attached..

One thing I do not undestand is to How to check if all the three cells i.e G2,G3 AND G4 are blank in one code without using arrays..

Originally Posted by contaminated

Try to use COUNTA function to determine if all three cells are empty. Forexample if =COUNTA(G2:G4) will retrn 0, this would mean then none of those cells are filled.

=IF(COUNTA(Range),ValueIfTrue,ValueIfFalse)

Yeah I should have thought of that!

Very stupid of me. But I was actually trying to avoid a default Blank Condition by giving Col A as incase if some other Col other than A is blank then that would not be attained with a default code..

Anyways, so far so good however if you can please explain the code incase if I need to expand on this logic it would be very useful....