Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

In this video, you can get five shortcuts that will save you time when writing XLOOKUP or VLOOKUP formulas. They include

00:00 Selecting Range References
01:55 Make References Absolute
04:20 Selecting a Column in a Table
06:50 Selecting the First Column in a Row
08:24 Navigating Between Sheets

If you’d like to read the accompanying blog post on my website, you can access it here: https://www.excelcampus.com/tips-shortcuts/xlookup-shortcuts

Related Videos:

When to use VLOOKUP instead of XLOOKUP:
https://www.youtube.com/watch?v=CQAhPRCAjA8

XLOOKUP for Excel: Explained in 3 Minutes:
https://www.youtube.com/watch?v=txK0C6SkaMg

The New XLOOKUP Function: Compared to VLOOKUP & INDEX MATCH in Excel:
https://www.youtube.com/watch?v=pURSha68Mjs

VLOOKUP Tutorial for Excel - Everything You Need To Know:
https://youtu.be/d3BYVQ6xIE4:



#MsExcel #ExcelCampus