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 do an X-Lookup Formula in Excel
The new kid on the block - so much more versatile than the 'V-Lookup'
365 Productivity
Excel Conditional Formatting Dates
Start by selecting a column of dates.
Click conditional formatting.
Highlight Cell Rules.
Click A Date Occurring.
Now choose your Date Occurring and Format Colour.
How to sort dates in your Power BI report.
Display the dates correctly in your Power BI reports and dashboards.