Hello readers and fans…
On behalf of my family, our staff, volunteers & well-wishers, Let me wish you a very happy Christmas & prosperous new year 2021. Here is a small holiday card from Chandoo.org HQ. The kids school had a cultural festival a month ago and we got this beautiful picture at a photo booth. So much better than timer controlled DSLR on our dining table, I must say.
Thank you
2020 has been a strange year. I know many of you would have faced some form of hardship this year. So I won’t bore you with my details. Instead, let me be thankful for what it has been. Big shoutout to…
- You – my dear reader, viewer and supporter of Chandoo.org for being with me all this time and learning.
- My family – for supporting & loving me all these years
- Microsoft – for creating Excel & Power BI
- YouTube – for providing an awesome platform to share my knowledge with you
- 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 & Global Excel Summit
- My staff – Ravindra, Pothi & 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
This holidays…
I feel incredibly fortunate to be living in New Zealand where covid is under control. This allows us to spend a bit of time outside our house during the holiday season. We are going a little road trip to Coromandel peninsula on the north-east side of NZ. I will share a post card from the beach when we get there by New Year.
Stay safe and 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.