Hello, all,

I have what would seem like a really easy task to do, and cannot seem to figure out how to do it...

I have a column on sheet2 which contains hyperlinked cells, all of which say "google". When clicked on, these cells follow their hyperlink, which performs a google search in a new browser window

What I am trying to do is a vlookup to values in this column from sheet1. I want the vlookup to return the true value of the cell, with hyperlink and all. It seems to default to returning just the text tag, the word "google".

I would also use a macro to accomplish this if it can be done. I have played around with using "hyperlink" in my vlookup statement, but it will only use the tag text value as the hyperlink anchor, again the word "google".

Is there any way to do this?

Thanks for the help!