Excel Page Navigation Hack

Using FILTER, XLOOKUP and HYPERLINK to create a drop down list navigation menu

=HYPERLINK("#"& CELL("address",XLOOKUP( F3, tblSections[List], tblSections[List]) ),"Go to")

Connect with me via the following link wyn.bio.link/

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")



Access Analytic
accessanalytic.com.au/