View Single Post
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

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