Creating bookmarks/hyperlinks to rows and columns

Hi, Can you please help with a suitable excel formula (without macros).

I have two sheets, Index and masterdata. Index sheet has S.No and Projects, masterdata sheets has S.No, Projects and other information.

I need to create bookmarks/hyperlink for S.No in Index sheet to masterdata's S.No.

In other words if I click on Index sheet S.No, it should take me to corresponding colums in masterdata's S.No.

Example : In the attached sheet If I click on A2 in Index sheet then it should take me to B1 in masterdata sheet and so on till nth row and column.

I tried using =HYPERLINK("#masterdata!B1",A2) but its not working as expected. and the row values are not incrementing.

Thanks,
Ravi

Hi,

See the attached...
(Compliments of HansV at Eileen's Lounge )

Good to know...