I have been bubbling with joy and excitement for almost 5 months now.. I don’t think I can hold it any longer. So here it goes,
We are becoming parents.
We have created a new cell and now that little cell multiplying fast. We are expecting the baby in first week of October.
It is very painful for us to stay in 2 different countries during such a beautiful and wonderful period. That is why I am going back to India tomorrow, for a 2 week vacation, to spend time with Jo. Now she is here and I am here
PS: That also means fewer posts during this break (I have scheduled some).
PPS: If you have some fun ideas on excel or charting and would like to write on PHD as a guest author, drop me a mail.
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.