Match two ranges are return Yes or No

[sMart_D1006]

Evening all, I am looking for some help if possible as i can not find the solution to my requirements online. I am OK with the basics but what i need is a little more complicated. Please excuse my explaining of what i am trying to do. I have attached an example of data to hopefully make better sense.

OK, so i have 2 worksheets, both have the same format data, A:A is month and year, B:B is a number. In sheet1 i need to find B1 in sheet2 B:B. I then need to know if found if sheet1 A1, matches the data in sheet2 A:A based on the result from the first result.

Thank you all in advance.
Mart

[jeffreybrown]

How about in C3 copied down...

=IF(ISNUMBER(MATCH(A3&B3,$E$3:$E$8&$F$3:$F$8,0)),"Yes","No")

IMPORTANT

• This is an array formula
• Enter the formula >> press F2 then >> CTRL + SHIFT + ENTER
• If entered correctly, the formula will be enclosed in {brackets}
• Do not enter the {brackets} manually

[jason.b75]

In C3 and fill down

=IFERROR(IF(INDEX($E$3:$E$8,MATCH(B3,$F$3:$F$8,0))=A3,"Yes","No"),"NA")

[sMart_D1006]

Thank you Jeff and Jason, both work

[jeffreybrown]

We are happy to help and you're welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.