I have atached a much simplified version of a spreadsheet I am using.
I have a master spreadsheet which shows agreeed rentals for vehicles, on the sample this is the "OCS" tab.
I receive a spreadsheet which contains the actual rental charged, in my example this is the tab "Invoice" in my example the VRN are in the same order on both sheets, in reality the invoice spreadsheet is not in the same order as my OCS sheet.
My task is to match the VRN field in the invoice sheet to the VRN in the OCS sheet, then look at the amounts and if they match then return "true" if they don't return "false
Thanks in advance for your help
Bookmarks