Hi Mary,

MATCH will only work in a single column. Which column in Sheet B did
you put the first formula in? That is the column you need to refer to
in the MATCH term (in my example it was column X).

Hope this helps.

Pete

On Oct 19, 1:32*am, "ms.maryw" wrote:
I like your idea, I must have did something wrong.

On sheet B I added

=B2&"_"&K2

On sheet A I added

=IF(ISNA(MATCH(A4&"_"&O4,B!$A$1:$M$43019,0)),"No Match","Match Found")

No matches were found.

Thanks, Mary