I have an exciting news for you, Yesterday I have mailed Charley Kyd – an Excel MVP, author of four books and 50+ articles for various national media, owner of exceluser.com and creator of popular products like plug-n-play excel dashboard kit. And he has agreed to give me an interview over phone / email.
The theme of the interview is “Excel in day to day work”
Here are few questions I have listed down:
- What are your 3 favorite formulas?
- What do you recommend a manager / analyst should learn in excel to be successful in work?
- Where do you think a lot of us waste time and effort when trying to get something done in excel?
- If I am an excel newbie what three books would you recommend?
- Do you think a desktop version of excel has a future in the world of web based computing and storage?
I need your help to get more question ideas, so please give me your suggestions through comments.
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.