VLOOKUP : Multi Condition

[chandrashekar]

Hello,

Can you please help me in formula to VLOOKUP based on multi condition.

Condition: Col A should match with Col E and if Col B(name) matches in Column G then I should get Yes else No

File: Sample data

Regards,
Chandrashekar B

 

[Fluff]

How about

=IF(AND(COUNTIFS(E:E,A2),COUNTIFS(G:G,B2)),"Yes","No")

 

[chandrashekar]

How about

=IF(AND(COUNTIFS(E:E,A2),COUNTIFS(G:G,B2)),"Yes","No")

Hi,

Thanks. I will check with real time data and get back to you.

Regards,
Chandrashekar B

 

[Fluff]

Ok

 

[chandrashekar]

Ok

Hello,

Thanks. It is working fine.

Regards,
Chandrashekar B

 

[Fluff]

You're welcome & thanks for the feedback.