Data mapping in excel

[boots647]

Hi
Iam trying to work out a formula or something that will tell me if a whole row matches.

let me explain I have two tables one table on each tab.

In these tables there shoud be matching data/rows but it could be anywhere in the second table
So i need to first find the right row in the second table and then i need to verify that the data correspondese to the data in the first table but in doing that each tables columns do not match so table 1 can be 30 columns but table 2 is 60 columns so i need to be able to first find the right row and then second find numourous columns in that row and ensure they match to the first table.

Can anyone help? i hope that made sense

 

[RobP]

Probably useful to share the column references that have data inside in both, so people can see which columns need to match which from each table ?

Rgds
Rob