VLOOKUP question

[attereco]

Hi Everyone,

Part of my job is to track financial transactions. I use a query that gives me all the transaction within a year. I run the query, add my info and save offline. Next day I run the query again and search for new entries not yet tracked. I do this by comparing my tracked table with the fresh query.
Each transaction receives an alphanumerical ID. VLOOKUP is great to compare the new query with the tracked list to find new IDs. The problem is that some new entries have the same IDs as old entries. These are correction charges, etc..
The below Vlookup would tell me that there are no new entries, whereas there is but with same ID. (of course there are thousands of lines, so I can't see the difference that easy..)

Is there a way to tell Vlookup to find a value ONLY ONCE in the given column? Or any other ideas to solve this? Thanks so much.

Tracked list	New query	Vlookup
0006100060	0006100060	0006100060
0006100169	0006100169	0006100169
0006100173	0006100173	0006100173
0006102234	0006100174	0006100174
0006100174	0006100177	0006100177
0006100177	0006102234	0006102234
	0006102234	0006102234

<tbody>
</tbody>

 

[Scott T]

This there something that is unique to the record or something you can combine that would be unique, like the Id and a date and timestamp? Like

	A	B	C
1	ID	entry timestamp	account
2	0006100060	1/9/17 7:00 PM	12-01-77-00

<tbody>
</tbody>

In the above you could join A2 and B2 to and look for that so instead of looking for 0006100060 you would looking for the value of ID and entry timestamp put together.

 

[attereco]

Thanks a lot Scott T, indeed this is a work around. Takes an extra few steps but works.