Hyperlink within a Combo Box?

[Afox10]

Hello All,

I've found great success from previous post and figured Id give it another shot. Example file is attached.

I am trying to create a searchable drop down list (combo list), that once the name is selected, I am able to "hyperlink" to a correlating table in the spreadsheet.

So for example, if we use the attached spreadsheet:
If we input M5, in the drop down list, I would then like to push 'GO' (or whatever can be created to work..) and have it go directly to the Machine5 table. Obviously the same process would need to follow with whatever machine is selected.

Any thoughts on this? As always, thank you for your time excel community!!

AFox

 

[deciog]

Check if this is the way you want

Decio

 

[Afox10]

@deciog

Perfect! Exactly what I was looking for.

 

[bosco_yip]

Another option without helper cells,

1] Select Developer >> Design Mode >> click "ComboBox" >> Properties >> Alphabetic >>

>> LinkedCell, enter : B3

>> ListFillRange, enter : MachineList

2] In Cell B4, enter formula :

=HYPERLINK("#R12C"&MATCH(B3,$12:$12,0),"GO")

3] Select M1~M5 from ComboBox, then, click B4 "GO"

Regards
Bosco

 

[deciog]

other way

Decio