Making your workbooks, charts, dashboards & presentations beautiful is a time consuming process. It is a mix of art & craft. Naturally, we spend hours polishing that important slideshow or visualization. But do you know about simple features in Excel that can save you a lot of time and help you create gorgeous output?
Formatting faster with paste special & double click
You may watch this video on our YouTube channel too.
More awesome & productive ways to format your reports
Formatting takes a major chunk of your Excel time. So why not pickup few shortcuts & techniques and become awesome? Check out below tips:
- Formatting shortcuts for you
- 8 tips to make you a formatting pro
- Format multiple sheets in one go with grouping feature
- Sexy on spreadsheet, ugly on printout? – tips for formatting printouts – podcast
- 10 tips to make boss-proof spreadsheets
Share your formatting routine…
Do you have a process / tip for formatting faster? Please share it in the comments. Celebrate Awesome August by sharing your knowledge. I am waiting to learn from you… go!
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.