using vlookup and hyperlink
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.
|