Match data from a table !!!

[G21]

Hi,
Im having 2sheets of data & in Sheet2 i have a table of data.eg -
A X
A Y
B Y

in sheet1 i have another set of data. I wanted to check those data are match with data in sheet2 table. ( both columns should match)if it match i need to mention "Yes" in 3rd column , if not "NO" .

A X YES
B X NO

pls help me to solve this .

Tks & RGDS,
G

 

[VoG]

Perhaps like this

Excel Workbook
	A	B	C
1	A	X	Yes
2	B	X	No
Sheet1

 

[T. Valko]

Hi,
Im having 2sheets of data & in Sheet2 i have a table of data.eg -
A X
A Y
B Y

in sheet1 i have another set of data. I wanted to check those data are match with data in sheet2 table. ( both columns should match)if it match i need to mention "Yes" in 3rd column , if not "NO" .

A X YES
B X NO

pls help me to solve this .

Tks & RGDS,
G

What version of Excel are you using?

Here's one way that will work in any version.

=IF(SUMPRODUCT(--(Sheet2!A$2:A$100=A2),--(Sheet2!B$2:B$100=B2))>0,"Yes","No")

Adjust the ranges to suit.

Copy down as needed.

 

[G21]

HI VOG, it works for a cell , but it does not work when i copy the same downwards to below cells.

HI Biff , its exactly works for my requirement.

Thanks both for your quick response ...

Really appreciate.

RGDS,
G

 

[T. Valko]

You're welcome. Thanks for the feedback!