Comparing Two Tables

Hi,

I have two tables on the same worksheet that I need to compare. The range of columns can vary anywhere from 2 to 10 so the code needs to be dynamic. If there are five columns of data in one table, I need to see if that array (A2:E2, A3:E3, A4:E4....etc) is found anywhere in the second table. If possible, I would like to output any changes into a different column.

We have tried to write code and have also attempted to alter code found on this forum without any luck. Everything we tried seemed to only compare the first column of the first table with the first column of second table.

Attached is a sample of my data.
If you look at the attached file, there are two tables. If you see, Vikings are preferred and level 1 and has no restrictions. On the 2nd table, the same exact entry appear on top of the table. I need to output "Found" in column K because it was found. If you look further down the orange table, Vikings appears again, but has a different level. The blue table does not have this entry so it should come up as "not found" in the output column. Another problem is if the row of data shows up twice in the 2nd table. If you at the data again, Falcons appear on the blue table as preferred and Level 1. On the Orange table, they also show up as Preferred and at Level 1, but this entry shows up twice. I need the output in either K to show up as "Found" for both entries.


I hope the description of what I need to do helped describe my problem. Any help would be much appreciated.

Steve