When I announced my upcoming Australian Excel masterclass, I got quite a few mails (ok, just a few), all which are on these lines,
Wow, I would love to meet you when you are here. Let me know if you have sometime on an evening for some coffee or beer?
That is no wonder,
Because down under,
Chandoo is popular.
😛
After saying yes to a few invitations, I saw the hassle in arranging several individual rendezvous. So here is an open invitation to you all. If you like Chandoo.org or fine Australian brewed coffee, clear your calender on below dates,
- Sydney – 30th April
- Brisbane – 2nd June
I am yet to decide the venue & time. But preferably, we will meet near water around 5ish in the evening. If you want to join me & share your Excel stories (or just any stories), fill up below form.
Thanks & I am eager to see you soon.
(In case you are not able to see the form, click here)
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.