Almost an year ago, my life took a pleasant, awesome turn. I became dad to two beautiful, naughty and energetic kids. We named them Nishanth & Nakshatra (meaning Moon & Star). Ever since they entered our world, our lives have changed. They bring laughter, love, anxiety and curiosity to our life everyday. And this Friday (24th Sept), they will be one year old.
To mark the occasion, we are having a mild extravaganza at our home in Vizag, India (here). I would be very happy if you can join us and bless our babies on this occasion.
If you are planning to come, just drop me an email at chandoo.d @ gmail.com and I will email you address and details.
Thank you.
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.