VLOOKUP Function
 

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

Try:

=CEILING(value,0.125)


"Chris Manning" wrote:

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

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.

"Duke Carey" wrote:

Try:

=CEILING(value,0.125)


"Chris Manning" wrote:

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