How to do an X-Lookup Formula in Excel
The new kid on the block - so much more versatile than the 'V-Lookup'
Keen to stay up to date on anything 365?
Sign up for tips and updates
You may also like
365 Productivity
Learn how to turn Microsoft Forms survey responses into actionable insights, charts and dashboards with Copilot in Excel
Build practical skills through Microsoft 365 training.
365 Productivity
Word Tip - Select Text with Similar Formatting
A quick fix for a formatting change.
Don't bother with the format painter - next time go to the Home Ribbon > Editing > Select > Select Text with Similar Formatting.
Then make your changes - Presto!, All similar text will also be updated throughout the document.
Copilot
How to personalise Copilot inside Excel