- We shifted, uneventfully that is. New house is demanding a considerable amount of travel, add to it lack of internet, that should explain the reason for nopost days.
- My plans for CalvinFund have taken a neat shape and currently the unbooked profits stand at 4-5%. But I am going to stop it and buy the book instead, thanks to my savings from the weeklong trip to Ireland.
- Office work has been hectic in a different way. I am trying to juggle along.
- Suddenly I am having difficulty in blogging, as if some monster under my bed is sucking away the creative juices when I am snoring. May be time for a break?
Who is my boss’s boss? [Data Analytics Challenge – 001]
Let’s try something different. I will share a data analytics challenge here. Post your solutions in the comments. Our first challenge involves Employee Data Analysis.
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.