Matching a duplicate row of numbers in a list of numbers in rows

Hi Forum,

I've been trying to figure out how to use Index/Match or ISERROR function in Excel to compare a row of selected numbers in a list of other numbers looking for an exact match. Any function in excel which would work better or simpler will do also.

I need to figure this out for a Lotto check spreadsheet that I've made which takes a set of numbers and looks for an exact match in a list of drawn numbers. I think I may need to use and array type function but it doesn't seem to work. I've attached a spreadsheet below which hopefully shows what I'm trying to do. If you look in the "Match" tab in cell H1 I'm trying a function which I hoped would look at the set of numbers A1:G1 and try to find an exact match from the "Drawn numbers" tab for any set of numbers in Rows 1 to 30 and state whether there is a matching set of numbers or not. The blank row in the "Drawn Numbers" worksheet is a bit of a test to see what would happen in the event of no numbers in a row. As you can see the function returns yes beside each row of number in the Match worksheet but those numbers don't match any rows of numbers in the Drawn numbers worksheet except for the last row which should match the last row on both worksheets. I hope this makes sense.

Thanks,

Sebastien.