Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
In this video, you’ll discover how to go directly to the source data of an XLOOKUP formula using a macro button in your Excel worksheet. If you’d like to read the accompanying blog post on my website, you can access it here: https://www.excelcampus.com/vba/xlookup-go-to-macro
Related Videos:
XLOOKUP for Excel: Explained in 3 Minutes: https://www.youtube.com/watch?v=txK0C6SkaMg&t=14s
How to Create a Personal Macro Workbook in Excel and Why You Need It: https://www.youtube.com/watch?v=rD2-mSbTuL0&t=69s
How to Add Macro Buttons to the Excel Ribbon or Quick Access Toolbar: https://www.youtube.com/watch?v=dmdolFcS-fI&t=12s
#MsExcel #ExcelCampus
00:00 Introduction
00:11 Jump to the Source of a Lookup Formula
01:44 How the Macro Works
04:30 Ways to Run the Macro