It is almost weekend. Today we (Jo and I) are going to watch a cricket match being played in Vizag. We are pretty excited as this is the first time we are watching a match in stadium.
So, let keep this light and fun. I want to know What is one area of Excel you want to learn more?
I will go first. I want to learn more about Data Tables & Simulation.
What about you? Go ahead and tell us using comments.
Note: Here are a few choices if do not know what else is out there.
- Formulas
- Array Formulas
- Formatting
- Conditional Formatting
- Charting
- Advanced Charting
- Pivot Tables & Charts
- Tables
- Data Tables
- Validation
- Filters & Sorting
- VBA (Macros)
- Linking to Databases etc.
- Solver
- Statistical Analysis (regression, time series etc.)
- Scenarios, What if analysis
- Dashboards
So go ahead and tell us.
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.