Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLOOKUP Help
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? I did see one solution that was posted on 5/31 involving adding code to the module, but my problem with that solution is that there are MANY cells that reference the same table, so that solution is out (it would involve adding near 4000 lines of code to the module. Any help is appreciated. Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
make a vlookup using a variable path | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions |