using vlookup and hyperlink
With search number in B1 and the lookup array C:D try the below. Adjust to suit
=HYPERLINK(VLOOKUP(B1,C:D,2,FALSE))
If this post helps click Yes
---------------
Jacob Skaria
"MJ" wrote:
I am using VLookup in column D that replicates a number from column B.
This works fine. What I would like to do is type the number into B and
have it populate D with not just the number from B, but provide a
hyperlink in D. If I put the hyperlink into my lookup table, the link does
not show up in D. I assume that I can use both vlookup and hyperlink, but
I am not sure how to use both for the same cell.
|