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
Bookmarks