Good news!!! We have upgraded the excel formula help page to a new, more easily accessible and better laid out page. Now the 50 formulas have been categorized in to 6 areas
- Mathematical Functions
- Text Functions
- Logical & Reference Functions
- Date & Time Functions
- Financial Functions
- Information Functions
Also, each formula has its own easy to remember url. For eg. you need help on countif formula, just type http://chandoo.org/excel-formulas/countif.html
This means, more of you can discover the formulas and help through search and sharing the links.
Remember, you can also buy an easy to read excel formula help e-book for just 5$.
Please spread the word about excel formula help page by stumbling it or tweeting about it or adding it to your delicious bookmarks. You will do me and this blog a very great favor by spreading the word.
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.