View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
akemeny akemeny is offline
external usenet poster
 
Posts: 63
Default Vlookup not calcuting correctly

I have two workbooks that I need to use a Vlookup on. Book1 contains a data
list of all the accounts. Book2 contains a smaller list of accounts already
reconciled. What I need the vlookup to do identify which accounts from Book1
are not on Book2.

This is the formula I'm using right now.

=VLOOKUP(A2,'[Trailblazer Section 1011 updated with final comments
(2).xls]Summary of Findings'!$A:$T,20,FALSE)

Any help would be greatly appreciated.