Matching Data with multiple columns

[Jimboted]

Hi All,

I am trying to sanity check data between two sets.

By way of example, the first set contains three columns - Name, Food, Band (columns A,B&C). The second set contains identical headings (columns D,E & F)

I need Excel to match the contents of column D with column A and the test whether column E matches column B and column F matches column C. Where this is true, I then need excel to display "TRUE", and "FALSE" where this is not the case (example attached with my formula).

I have tried to do this with a combination of IF, VLOOKUP and AND - but its not working. Can anyone suggest what I am doing wrong, or a better way to do this?#

Please see attached example.

Thanks,


Jim,