I celebrated 2007 three and half hours earlier and now I am celebrating 2008 ten and half hours later than usual. But no complaints though.
2007 has seen me through lot of personal and professional changes, I got married, moved to a house in Thiruvanmiyur, purchased a small house for my bro in Hyderabad, got a bike (manmadhudu), upgraded my comp (madhu), got addicted to excel and good food, been to some of the nicest places in this planet, made reasonable advancements in work life, lost my grand mother, got my brother married and met several new and interesting people.
But above all 2007 has been one of the happiest years of my life. I hope the flow continues in 2008, not just for me, but every one of us. I wish you all a very happy new year, lets hope each of us will find what we are looking for.
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.