Hello readers,
On behalf of my family, our staff, volunteers & well-wishers, Let me wish you a very happy Christmas & prosperous new year 2020. Here is a small holiday card from Chandoo.org HQ. This year, we have a new addition to our family – Excel, bichon-poodle puppy has been with us for a little over one month and already became a big part of our lives. I will share more stories about her next year.
Thank you
This is 10th Christmas since I left my job to make Chandoo.org my full time mission and passion. I am grateful to many for all the blessings, challenges, opportunities and experiences showered upon me. I want to say my heartfelt thanks for,
- You – my dear reader and supporter of Chandoo.org
- My family – for supporting & loving me all these years
- Microsoft – for creating Excel & Power BI
- My teachers – too many to name, but they have always guided & inspired me
- My partners – for helping my business and customers – big shout out to Plum Solutions & De Jonker Consultancy
- My staff – Ravindra, Pothi, Faseeh & Chitti for being a part of our team and running our small kingdom smoothly
- Our forum members – for lending hand to those who need help
- My customers – more than 25,000 of them. Thank you for trusting me.
- Blog friends – for sharing ideas and referring people to Chandoo.org
- Software providers – for helping me run Chandoo.org – big shout out to WordPress, Elementor, Stripe, E-Junkie, WishlistMember, KnownHost, ConvertKit, Amazon, Gmail and Techsmith
See you all next year with awesome Excel & Power BI goodness. Enjoy your holidays.
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.