As I am doing a road-trip across parts of southern India (we are in the beautiful temple town of Madurai as you read this post), here is something to keep you busy.
Fill in the blanks & post in comments.
I struggle doing _________________ with Excel.
I will go first.
I struggle doing statistical analysiswith Excel.
Now your turn.
You can leave a comment or post it on our facebook page.
And if you struggle with everything, then start with our Excel Basics & head over to Advanced Excel skills page.
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.