Your example helped me understand how to right the formula that fits what I
wanted.
Thanks very much

"Pete_UK" wrote:

Suppose you have a list of names in A1:A12 of Sheet2, and in A1 of
Sheet1 you have a drop-down to enable you to select from that list of
names. Put this formula in B1 of Sheet1:

=HYPERLINK("#Sheet2!A"&MATCH(A1,Sheet2!A1:A12,0)," Click to jump
there")

It will display "Click to jump there" in the cell and if you you click
on B1 the cursor will jump to the cell in Sheet2 which matches the
name you have chosen in A1 of Sheet1 - is this what you want?

Hope this helps.

Pete


On Aug 17, 11:03 pm, bgkgmg wrote:
Im not sure what URL is but if it means the same workbook then yes. I have
pasted in your response and I probably did not change somthing where I should
have. Could you post again and perhaps underline what I am to add.

Thanks
Bobby



"Barb Reinhardt" wrote:
Is the selection already a URL, or do you have a URL to match the value in
the drop down list?

"bgkgmg" wrote:

Can I create a HYPERLINK from a drop-down list?

Thanks
Bobby- Hide quoted text -

- Show quoted text -