Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I access data stored in a SQL server for vlookup function? | Excel Worksheet Functions | |||
VLOOKUP Function using Data Ranges. | Excel Worksheet Functions | |||
Array Function with VLOOKUP | Excel Worksheet Functions | |||
Simplify Vlookup function in Excel | Excel Worksheet Functions | |||
Vlookup w/Date Function | Excel Worksheet Functions |