Dilbert is my favorite cartoon (Calvin & Hobbes comes second). I like it so much that I have named this blog after Dilbert. So, today, as as ode to Dilbert and all things excel, we present you… Dilbert on Excel.
Boss with a spreadsheet
Related: Make boss proof spreadsheets
C23 in a Bad Mood
Can I do that in Excel
Related: Do you know what excel cannot do?
I have an excel formula
Financial Modeling on my own
NPV of Ant Milk!
Related: What the heck is NPV anyway?
Manage by Spreadsheet
MBAs and Spreadsheets
Numbers Don’t Lie
Related: Common Formula Errors and Their Fixes
ROPRTGRESTA !!!
Go Track Yourself
Unprotected Spreadsheets
Related: How to hide a cell
Happy weekend folks. See you all next week with fresh new tips and tricks.
PS: All cartoons are copyrighted to Dilbert.com. Click on them to go to Dilbert.com.
One Response to “How to compare two Excel sheets using VLOOKUP? [FREE Template]”
Maybe I missed it, but this method doesn't include data from James that isn't contained in Sara's data.
I added a new sheet, and named the ranges for Sara and James.
Maybe something like:
B2: =SORT(UNIQUE(VSTACK(SaraCust, JamesCust)))
C2: =XLOOKUP(B2#,SaraCust,SaraPaid,"Missing")
D2: =XLOOKUP(B2#,JamesCust, JamesPaid,"Missing")
E2: =IF(ISERROR(C2#+D2#),"Missing",IF(C2#=D2#,"Yes","No"))
Then we can still do similar conditional formatting. But this will pull in data missing from Sara's sheet as well.