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 [ Ссылка ]

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
[ Ссылка ]

свернуть