This formula check data in C1,D1 in A:A & B:B could it be extended to check of
D1,E1 & F1 in A:A, B:B & C:C ?
formula is
=IF(C2="", "", IF(D2=INDEX(B$2:B$65536, MATCH(C2,A$2:A$65536, 0)), "", "mismatch"))

Let me describe it clearly my friend....
I have Data based On three columns A is Container No. B=Destination C Quantity of packages and Same Data we receive From the Terminal So i place my Data in the data i receive from the terminal in 1 sheet and Check either container No. aphu-1234567 for Destination NYH with Quantity 123 is same In the Terminals record or not...
sometimes we have wrong container no or terminal provides wrong container no. for e.g: Aphu1234568 or Destination is given wrong! or Quantity of packages is given wrong...
for eg Container No with us is UESU1234567 and terminals record says APHU1234567 so we need to check that!... or Destination with us is NHY (New York) terminal gives it for CCO (Chicago)
1. In case of Match cell will remain blank..
2. well it results in to #N/A if C2 is Not found in A:A it gives #NA for container
3. IF D2 is not found in B:B so it given Mismatch....and for Dest. or QTY
4. there cannot be more then 1 same Container No. with same Prefix and No.
Well based on extending the fromula into 3 X 3 columns if container is not Found so formula should says Box Mismatch, if destination so it should says Dest Mismatch and sames for Quantity...

1. Data consists of three items - Container No. , Destination and Quantity of packages
2. our data is in 1 sheet
3.Data in 2 sheet & then i place Our in is ABC & Terminals data in DEF..so DEF shall check A:A B:B & C:C
4. we need to compare Terminals data with Our data.exactly Can differ in any Items..
5. Container should match each other destination with destination and QTY with QTY but condition is that 3 items checking should be interlinked!..& Each Item matches..for eg IF terminals data is in Row 54 and and Our data is in Row 2 so checking should be based on the Dynamic range..not row to row checking...
6. IF the Container no. is not same in both so it should show Container Mismatch, IF Destination so Destination mismatch If both Container and Destination are same and QTY is not so it should say QTY Mismatch