Match / Index Multiple Columns and copy data

Not sure which you opted for but I for one failed to add the SUBSTITUTE as I should have done to the concatenation formula such that it becomes:

=SUBSTITUTE($A2&"@"&$B2&"@"&$C2," ","")
copied down

The other formula remains as was...

I did a quick benchmark test between the exact match approach and the binary search ... using your file and on my machine (4GB RAM) the exact match takes around 4 secs to calculate (700 calcs) whereas the binary search takes around a hundreth of a second.

Though 4 seconds is not long it does prove the gains that can be had from sorting and using binary search methods as only a fraction of the transactions are reviewed (savings will increase the greater the range / no. of calcs)

EDIT: apologies for the edits - trying to word correctly such that it made sense.