Compare data in column result in row as yes or no formula

[johnodys]

Hi experts

I have set of data in range with column of 4 CITY,COUNTRY,REGION,BUSINESS in the business column contains 2bd,3bd,4bd,5bd

i have another set of data range with column CITY,COUNTRY,REGION, and 2BD 3BD 4BD 5BD i want result in last four column
compare with range 1...... if exist city,country,region in set1 then businss is 2bd in the result 2bd YES REST OF VALUES ARE NO.

i want result expected with compare data set of data result as YES OR NO

find the attachment you may get understand..

[ajryan88]

Hi,

In cell J2, enter this formula:

Please Login or Register  to view this content.

Then drag it across and down.

Hope this helps

[Fotis1991]

In J3 and copy down and across, try this.

=IF(SUMPRODUCT(($A$2:$A$5=$G3)*($B$2:$B$5=$H3)*($C$2:$C$5=$I3)*($D$2:$D$5=J$2)),"YES","NO")

[johnodys]

Nice Dude Perfect Piece of work......thanks alot

[ajryan88]

Hi John,

Just curious which answer you used?

Also, please don't forget to click on the * next to any post that you feel has been of great assistance to you

Have a great day