Excel Page Navigation Hack
Wyn Hopkins
![Wyn Hopkins]()
Wyn Hopkins
Solving data challenges for companies and people. Power BI | Excel | Fabric | Solver Budgeting & Consolidation. Part of the Amazing team at Access Analytic Microsoft MVP ??6 Million+ YouTube views
Using FILTER, XLOOKUP and HYPERLINK to create a drop down list navigation menu
Here's the code
=HYPERLINK("#"& CELL("address",XLOOKUP( F3, tblSections[List], tblSections[List]) ),"Go to")
And a further trick if you want to jump to a specific column for the identified row would be
=HYPERLINK("#"&ADDRESS(ROW(XLOOKUP( F3, tblSections[List], tblSections[List])) ,3),"Go to")
Connect with me via the following link https://wyn.bio.link/
Access Analytic blog: https://accessanalytic.com.au/blog/
Wyn
Experienced Director/Senior Manager specializing in Financial Management, Data Analytics, and Business Intelligence.
3 年Wyn, this tip is extremely useful since I am running Excel 365. It would be nice to design a hyperlink to jump to other tabs. Regards
Supporting an audacious program to make green energy to the world.
3 年Hyperlink is a new friend. I have a standard vba generated table I now use, which: 1. Retrieves the names of all tables and their sheet location, 2. Adds a hyperlink formula for navigation. 3. If the table is named 'qry_....' runs the Powerquery. I use this everywhere!
Freelance en Excel 365, Power BI
3 年This its marks the difference of Microsoft 365, thanks for sharing Wyn. Regards