whatsapro
05-22-2016, 04:41 PM
All,
Second post. I'm amazed at the help so far. Thank you.
I have Cell, say D3 that contains a value, "0123444444".
In another cell, T3, there is a hyperlink that was pulled in from another workbook entirely. So the "value" is the actual hyperlink. There is a VLOOKUP pulling this data into my sheet.
How can I make the D3 still show "0123444444" and then make it reference that "value" in T3 still? I've tried =HYPERLINK(T3,"0123444444") but that is not working. I'm assuming its because the cell T3 is actually a VLOOKUP formula?
Any suggestions?
Second post. I'm amazed at the help so far. Thank you.
I have Cell, say D3 that contains a value, "0123444444".
In another cell, T3, there is a hyperlink that was pulled in from another workbook entirely. So the "value" is the actual hyperlink. There is a VLOOKUP pulling this data into my sheet.
How can I make the D3 still show "0123444444" and then make it reference that "value" in T3 still? I've tried =HYPERLINK(T3,"0123444444") but that is not working. I'm assuming its because the cell T3 is actually a VLOOKUP formula?
Any suggestions?