Forum Discussion
V look up
Can someone point me in the direction of learning v look ups for financial statement reconciliations
reconciling two sets of data
1. supplier statement
2. purchase ledger data
It could be 10 lines it could be 200/300 lines, sometimes the invoice number are pre formatted to remove prefix of letters on supplier statement
Date Invoice Number Value
currently I use conditional formatting duplicate values against invoice number column & value to check for exact matches I then physically check any none matches. I just wondered if V look up would make it easier or any other suggestions?
Is it possible for you to post copies of the spreadsheet(s) you're working with. Put them on OneDrive or GoogleDrive (or some comparable cloud service) and give us a link here.
Since you're using conditional formatting, you must already be using some form of matching...
Anyway, if you could grant access to an actual example, that would help us help you.
Since you're using conditional formatting, you must already be using some form of matching...
Anyway, if you could grant access to an actual example, that would help us help you.