Wellington(NZ) sure is beautiful on a clear day. There are so many cool bike tracks, walking trails and beaches to keep you busy. Today, I went cycling on my usual route towards Makara beach. At the turn off point, I thought, “This is selfish. I can’t keep all this beauty to myself. I must share it with you.” So here we go.
A quick video about data analysis while on bike
Technically, I was not on bike when recording this video. Watch it below or on our YouTube Channel.
Time to learn all about Pivot Tables:
For more information about Pivot Tables, check out below resources.
- Introduction to Pivot Tables
- Relationships & Data modeling in Excel
- Top 10 Pivot Table tricks for you
- [Advanced] – How to use GETPIVOTDATA to automate your dashboards
- [Advanced] – Create a dynamic dashboard with Pivot Tables & Slicers
- [Advanced] – Comprehensive guide to Pivot Tables
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.