How to do an X-Lookup Formula in Excel

Keen to stay up to date on anything 365?
Sign up for tips and updates
You may also like

365 Productivity
How to Clear filters with a shortcut
Use Tables - Ctrl + T
Then add Slicers to make filtering easier, finally use the sequential shortcut Alt then A, then C to clear filters. Remember Alt All Clear!

365 Productivity
QR Codes
When to use them and how to create a QR Code for your Website - it's quick and easy and an efficient way to share information.

365 Productivity
Pivot Table Hack - Report Filter Pages
Need to create a quick pivot table for each product, each location or maybe each salesperson? Use this simple technique using Report Filter Pages!