Alternative to V Lookup?

[lauz125]

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Each month I have to reconcile approx 50 supplier accounts by comparing what is on the statement to what is on our system. The idea is for the system to be identical to the statement.<o></o>
<o> </o>
We have 3 systems, so I am comparing 4 peices of data:<o></o>
1. System 1<o></o>
2. System 2<o></o>
3. System 3<o></o>
4. Supplier Statement<o></o>
<o> </o>
The aim of the reconciliation is as follows:<o></o>

• To ensure all invoices on the statement appear on either system 1, 2 or 3.<o></o>
• To ensure all invoices are entered onto the system at the correct invoice total<o></o>
• To ensure that there are no invoices on the system that aren't on the statement (or we will be paying for things that aren't outstanding!)<o></o>
• To ensure that invoices are only entered onto one system (any invoices entered onto more than one system need to be identified and deleted before they are paid twice)<o></o>

<o> </o>
Normally, I would use a straight forward V Lookup. But as V Lookup doesn't spot duplicates it wouldn't do the job.<o></o>
<o> </o>
Can anyone please suggest a quicker and more efficient way to complete these reconciliations? I have attached a document with a sample of the information I want to reconcile (obviously this isn't the real info, I have made it up due to privacy reasons)<o></o>
<o> </o>
Thanks in advance<o></o>

 

[lauz125]

I don't know how to attach the document sorry!