Lookup values with multi criteria

[Deepak Sharma]

Hi All,

Please help to resolve this.

I Need result on G column FROM H column of Database sheet as per the above conditions, If any cell in K2:K6 gets equal to "Y", then it should search as per that criteria only.

Two conditions can be the be same, that can be any out of 5, Need to search as per these conditions, challenge is any conditions can increase as well, like If K2 & K3 & k6 can be = "Y", OR k2 & k3& k4 can be = "Y" etc. etc. etc.

I think LOOP can work in this. Please help.

Please see the attached sheet

I have applied below formula but it satisfies two criterias only.

{=IFERROR(IF(AND($K$2="Y",$K$3="Y"),INDEX(Database!H:H,MATCH(1,($A2=Database!J:J)*($B2=Database!G:G),0))),"N/A")}


Regards,

 

[vletm]

Deepak Sharma
Something like this ...?

 

[Deepak Sharma]

That was Amazing Vletm! Thank you for your effort made. However, If you could review it again please Because It's storing the first result Only, which it is founding as per the criteria and showing that SAME result for other match found records OR Duplicate records.

Please see the red marked entries.

Regards,
Deepak Sharma

 

[vletm]

Deepak Sharma
What is wrong with the 1st record ...
or sometimes ...
I modified some parts ...
You could continue from this, could You?

 

[Deepak Sharma]

Amazing vletm, This is working perfectly Bro! Thank you so so much for this help!