VLOOKUP Function

G

Guest

What I'm trying to do is have the VLOOKUP function return the actual formula
in the reference cell (Specifically, it is a HYPERLINK command) and what
happens is that the VLOOKUP function returns only the "freindly name" of the
hyperlink; that is, the link location is another place in the workbook, but
it returns what is displayed in the hyperlink cell. Is there any way to do
this, perhaps with another function, or modifying the VLOOKUP command? Any
Help is appreciated.

Chris
 
G

Guest

I'm not sure that post was in the right thread. Anyways, I just wanted to
clarify that I did find a solution to this exact problem on the forum, but
the problem is that this formula would need to be applied to many cells, so
that I cannot use the solution given on 5/31.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP Help 2
Hyperlinks 2
Vlookup error? 6
VLOOKUP Problem 1
vlookup inside a hyperlink 1
Vlookup on blank cells formatted with dates 3
Vlookup and Trace Return Cell 2
VLOOKUP Problem 1

Top