On Sat, 22 Nov 2008 18:53:51 GMT, Lars-Åke Aspelin
wrote:

On Sat, 22 Nov 2008 09:32:00 -0800, Nelson
wrote:

Hi,
I facing one problem about match or look up more than two same data.
Example:

a b z
c d z
e f z
a c z
a b z

if I want the result show "Yes" or just a remark in "z" when "a" and "b"
appear two times or more. "c" and "d" , "e" and "f" , "a" and "c" show "No"
or other remark.

I know Vlookup function is only can look up one data.
Please help me solve this problem.
Thank you


Try this forumula in cell C1:

=IF(SUMPRODUCT((A$:A$5=A1)*(B$1:B$5=B1))1,"Yes", "No")

Copy it down for as many rows that you have data.

Hope this helps / Lars-Åke

Sorry, there was a missing 1 in the formula.

=IF(SUMPRODUCT((A$1:A$5=A1)*(B$1:B$5=B1))1,"Yes", "No")

And change the 5's to suit the number of data rows that you have

/ Lars-Åke