I am using a VLOOKUP function. The problem I face is ..

In List 1:

John Smith (ID 12345) has amount $500
John Smith (ID 12345) has amount $1000


In List 2:
John Smith (ID 12345) has amount $1000
John Smith (ID 12345) has amount $500


When I complete my VLOOKUP, the result end us being:

John Smith (ID 12345) $500
John Smith (ID 12345) $500

How do I avoid the above? it doesn't pick up the $1000