Flag up purchases made when the card was in a different location to associated vehicle

Hi everyone, looking for a formula to see if a purchase made against a vehicle reg (column transaction VRN in the purchase data tab) is between a two vehicle stops in the stop data.

In the example the purchases in green on the purchase data tab can be verified as the vehicle was stopped at that time at the petrol station. I have a formula already to see if the vehicle stopped at the petrol station, but need a formula to verify the purchase.

The objective is to flag up purchases made using the vehicle's card when the associated vehicle wasn’t there.

There is a suspicious purchase in this dataset - row 4 in the purchase data tab - this is suspicious as at this point the card was used but the vehicle was not stopped at the petrol station.


Thanks!!!!

UPDATE 14.04.2020 - now included formulas to highlight whether vehicle has entered petrol station geozone