Pulling a Hyperlink through to a cell using INDEX and MATCH

I think result of INDEX/MATCH should be an address (reference) like A1 or Sheet!A1, whatever... but address
example:
in the same sheet
=HYPERLINK("#A1","click")
in the same workbook
=HYPERLINK("#Sheet5!A1","click")
to another workbook (must be open!)
=IFERROR(HYPERLINK("#'[series and sequences.xlsm]ConcatenateRange'!$A$1","click"),"") (IFERROR doesn't work because HYPERLINK() [Excel] has own error handling)
to a(the?) site
=HYPERLINK("http://www.excelforum.com/excel-formulas-and-functions/","click") - in this case: no #

red is important

Link is a text so you can use text functions between "# ", ie. =HYPERLINK("#INDIRECT(C4)","click") where value of cell C4 is text VIP1, so after click it will jump directly to cell VIP1 (here is a link in the same sheet)

but maybe I am wrong

note: all above was tested with success

would be fine to see any attachment with example excel file or try: HYPERLINK("#INDEX($AH$3:$AH$349,MATCH(C6,$AA$3:$AA$349,0))","click") - it works , moving selector to the result of formula. [on my ranges but it doesn't matter]. I just simply forgot that result 'in background' is an address. shame on me

Hi, welcome to the forum

I think the problem is this...

I am just wondering if there is any way to pull a 'live' hyperlink through from an existing table on a spreadsheet to another part of the spreadsheet and it still operate.

I dont believe there is anyway to pull a hyperlink from somewhere else, using a formula, and have it work...sort of like sheet1!A1 contains a HL, and sheet2 B2 =sheet1!A1 and then want that HL in sheet2 to work

You may be able to do a work-around by pulling in the contents of "A1", and then creating a HL from that - but a direct reference - I dont think that can be done

If you do this:

Please Login or Register  to view this content.

it will shows result of formula and will be as link to .... somewhere

example:

Please Login or Register  to view this content.

If result of formula will be an address like A1 put the same formula in two places. Don't forget about quotation marks where they are or .... not.
hope it's what you want