Hello,
I am hoping to ask some assistance in a formula to bring over a hyperlink from [FONT=inherit !important][FONT=inherit !important]the [/FONT][FONT=inherit !important]cell[/FONT][/FONT] that I am using the[FONT=inherit !important][FONT=inherit !important]INDEX[/FONT][/FONT]/MATCH formula to bring over. (sorry for all of the hyperlink questions - there is something specific I am trying to accomplish on a deadline! I do very much appreciate any offers of help!)
My current formula:
=IF(ISNA(INDEX(Edit,MATCH(A14,Name,0))),"",INDEX(Edit,MATCH(S15,Name,0)))
Edit and Name are both defined names in the Name Manager of the workbook.
How would I incorporate a HYPERLINK formula to bring over the hyperlink that is in the cell that the INDEX/MATCH formula is grabbing?
Also, in case it makes a difference, the link in the cells that the INDEX/MATCH formula is grabbing is a link that goes to to another location within the workbook (not to the web or external location)
Thank you for your assistance!
I am hoping to ask some assistance in a formula to bring over a hyperlink from [FONT=inherit !important][FONT=inherit !important]the [/FONT][FONT=inherit !important]cell[/FONT][/FONT] that I am using the[FONT=inherit !important][FONT=inherit !important]INDEX[/FONT][/FONT]/MATCH formula to bring over. (sorry for all of the hyperlink questions - there is something specific I am trying to accomplish on a deadline! I do very much appreciate any offers of help!)
My current formula:
=IF(ISNA(INDEX(Edit,MATCH(A14,Name,0))),"",INDEX(Edit,MATCH(S15,Name,0)))
Edit and Name are both defined names in the Name Manager of the workbook.
How would I incorporate a HYPERLINK formula to bring over the hyperlink that is in the cell that the INDEX/MATCH formula is grabbing?
Also, in case it makes a difference, the link in the cells that the INDEX/MATCH formula is grabbing is a link that goes to to another location within the workbook (not to the web or external location)
Thank you for your assistance!
