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
I am using the following formula
- Surname
- Date of departure
- Amount
- From / departure point
[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