Vlookup not calcuting correctly
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.
"Pete_UK" wrote:
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.
|