Hi friends,
I have a surprise for you. Between the late night world-cup matches & my reinvigorated thirst for biking, I have difficulty finding time to write a long & detailed article for you. So I thought why not say hello to you and share an Excel tip while I am on a biking trip.
Go ahead and watch it below. Its just 4 minutes.
(Sorry for poor audio, next time I will carry a clip-on mic for better capture)
An Excel charting tip + bike ride
Watch it below or on our YouTube channel.
For more on this charting technique, check out Dynamic Charts using Filters.
Also, check out the previous bike trip + Excel tip if you want more.
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.