Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
make VLINKUP like vlookup; smart hyperlink by data value
Instead of using VLOOKUP to bring back a cell value, I want to GO to that
location by double-clicking. VLINKUP would have the same sorting, first-column requirements as VLOOKUP, and a "not found" should envoke a NOT FOUND msgbox. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
make VLINKUP like vlookup; smart hyperlink by data value
Ctrl + g.
Enter cell reference. Regards, Ryan-- -- RyGuy "wizard61" wrote: Instead of using VLOOKUP to bring back a cell value, I want to GO to that location by double-clicking. VLINKUP would have the same sorting, first-column requirements as VLOOKUP, and a "not found" should envoke a NOT FOUND msgbox. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
make VLINKUP like vlookup; smart hyperlink by data value
Sure, and I could also manually fetch the individual cells that VLOOKUP pulls
automatically, but I prefer VLOOKUP because it is dynamic. I want VLINKUP to go to the cell that VLOOKUP would have pulled from. Dynamic. Data driven. Smart. Automatic. I was hoping the VLOOKUP/VLINKUP name similarity would show the way. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
make VLINKUP like vlookup; smart hyperlink by data value
Have you looked into using the HYPERLINK formula?
Pete On May 16, 1:09*am, wizard61 wrote: Instead of using VLOOKUP to bring back a cell value, I want to GO to that location by double-clicking. *VLINKUP would have the same sorting, first-column requirements as VLOOKUP, and a "not found" should envoke a NOT FOUND msgbox. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm....mspx?mid=57e4... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a hyperlink run a macro? | Excel Discussion (Misc queries) | |||
Getting data from two cells to make a hyperlink | Excel Discussion (Misc queries) | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
make the cell hyperlink to any name within it | New Users to Excel | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) |