INDEX & MATCH duplicate entry

Hi all,
I have a master Data sheet with a lot of information and what I need to do on monthly basis is to validate this data and cross reference it against what has been submitted by the 3rd party.
I have made a formula that searches, matches and returns the Data if its correct (refer to the attached excel file, column O and P) .

There is a catch though... some of the data have duplicate reference numbers (for example same docket numbers) and when i run the formula its unable to distinguish whether if its a double up and ultimately the formula reference the incorrect details.

Would you be able to assist me with a way to get around this?

Please note that I cannot modify and rename the docket names with the same reference numbers.

Many Thanks

ScreenShot00086.jpg

Hello Alx19 and Welcome to Excel Forum.
The following seems to work for the highlighted rows (169:170): =INDEX(RRJun!J:J,MATCH($B169&$H169&$E169,RRJun!$R:$R,0))
Note that column R on the RRJun! sheet, referenced in the formula, is populated using: =I2&G2&E2
Also note that when copied up the formula causes O166:P166 and O164:P164 to display #N/A because on the RRJun! sheet the Qty is reported as 5.67 whereas on the Ocon sheet the Qty is separated (1 and 4.67).
These particular formulas may not work for your situation however there may be some other column(s) on the RRJun! sheet which could be used to isolate Chk-cc and Chk-Amount values and that could be included on the Ocon sheet. If so, the method would be similar to the way the three columns in the above formula are used.
Let us know if you have any questions.