VLOOKUP question

attereco

New Member
Joined
Jan 11, 2017
Messages
2
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 listNew queryVlookup
000610006000061000600006100060
000610016900061001690006100169
000610017300061001730006100173
000610223400061001740006100174
000610017400061001770006100177
000610017700061022340006102234
00061022340006102234

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Scott T

Well-known Member
Joined
Dec 14, 2016
Messages
2,615
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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

New Member
Joined
Jan 11, 2017
Messages
2
Thanks a lot Scott T, indeed this is a work around. Takes an extra few steps but works.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,577
Messages
5,596,996
Members
414,116
Latest member
sfullnet

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top