You could try something like this:

=IF(ISNA(MATCH(A2,'[Trailblazer Section 1011 updated with final
comments(2).xls]Summary of Findings'!$A:$A,0)),"absent","present")

then copy down as required.

Hope this helps.

Pete

On Jun 4, 2:07*pm, akemeny wrote:
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.