Hi, hoping this is possible and someone can help...

I'm trying to create a formula to make a hyperlink, based on two cells - both with a data validation list drop-down box. The hyperlink is to jump to a certain tab and cell within the same document.


1st Dropdown box in A2 contains a customer account name - this will be cell position within each tab
2nd Dropdown box in B2 contains the tab name.

I understand the correct formula is along the lines of 
Please Login or Register  to view this content.
I've tried various ways to make it do what I want, but always get the error of 'cannot open the specified file'

My most recent attempt: 
Please Login or Register  to view this content.