Vlookup not calcuting correctly

[akemeny]

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.

 

[Pete_UK]

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

 

[akemeny]

I like the way that formats by actually saying absent or present, but it
still overlooks the ones that are present and marks everything as absent.

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

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.

 

[Pete_UK]

In that case it is not finding any exact matches.

You may have numbers in column A of one workbook, but in the other
workbook these are text values (which happen to look like numbers.
Alternatively, these may be text values in both, but you may have
extra spaces (or non-breaking space characters) in one column compared
with the other.

If you can give some examples of what is in column A of both sheets I
may be able to suggest ways of overcoming these differences with an
amended formula.

Pete

I like the way that formats by actually saying absent or present, but it
still overlooks the ones that are present and marks everything as absent.

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

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.- Hide quoted text -

- Show quoted text -