Vlookup not finding certain values

[mossdata]

I exported 2 transaction detail reports from 2 separate QuickBooks files representing all the transactions involving the Accounts Payable general ledger accounts.  This exercise is to discover transactions in one file that are not contained in the other file.  I'm using Vlookup but perhaps this is the wrong approach.  Row 7317 is just one example but there are many rows returning #N/A that should find a corresponding value.  You can see in the other file (tab) that the corresponding transaction exists (row 7351). 

Then there is the issue of how Vlookup handles duplicate amounts in multiple rows, Will Vlookup  always return the first row it finds working from top to bottom in the target area?

[#2 · Accepted solution]

@mossdata 

You can see in the other file (tab) that the corresponding transaction exists (row 7351). 

---

Your VLOOKUP() only searches up to row 7047.

[#3]

@Detlef Lewin Thanks!

[#4]

And how do you fix this? How can you make the VLOOKUP to read further than that cell? Thank you :) @Detlef Lewin 

[#5]

@franciscopserra 

I guess to change the range