Solved: Index / Match Multiple Criteria Issue

[demetre]

Good afternoon All

I have an issue in regard to my formula which uses a index / match with mutiple criteria.

In essence I want to reconcile the two sheets based on

1. Surname
2. Date of departure
3. Amount
4. From / departure point

I am using the following formula
[vba]
=IF(ISNA(AND(MATCH(File1!$A2,File2!$A$1:$A$6,0),MATCH(File1!$B2,File2!$B$1: $B$6,0), MATCH(File1!$C2,File2!$C$1:$C$6,0),MATCH(File1!$D2,File2!$D$1:$D$6,0))),"Ma tch","No Match")
[/vba]

The results should match the cell data but the logical arguments are not applied for some reason. The error is eluding me at present, woudl someone be kind to assist.

I have attached a test workbook to highlight my issue.
thanks in advance

Also I forgot to add that the original lookup sheet's (sheet1) data is assumed to be correct, and the sheet 2 is the comparable sheet which may / may not contain data from sheet1. Also sheet 1's data is correct for the whole row, not just for that one cell.

regards