In the 33rd session of Chandoo.org podcast, let’s turn the mic to our listeners and hear their tips.
What is in this session?
This session has 2 things.
- A surprise Easter egg (an Excel tip hidden in the podcast audio)
- Collection of Excel tips recorded & submitted by Chandoo.org readers
Listen to this session
Podcast: Play in new window | Download
Subscribe: RSS
Click here to download the MP3 file.
Links & Resources mentioned in this podcast
Keyboard & Mouse shortcuts
Chart formatting tips:
Transcript of this session:
Download this podcast transcript [PDF]
Did you find the Easter egg?
Now that you found the Easter egg, it is your turn. Go ahead and leave a comment with cryptic message. Share your favorite Excel tip or ideas with us.
Thanks to the contributors
Many many thanks to both Roberts, Micky, TJ, Val & Orkun. It was fun learning from 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.