Excel - How to create hyperlink to specific cell based on multiple criteria

preview_player
Показать описание
In this video I show how to create hyperlink using function in Excel.
There are used criteria from drop down lists to navigate to specific sheet and cell.
With HYPERLINK function I combined MATCH, MATCHIFS and INDIRECT functions to make it variable.
Рекомендации по теме
Комментарии
Автор

Thanks for the tips, was really helpful

savanthk