Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup and hyperlinks
Is it possible to use Vlookup and grab the hyperlink from the cell? If so,
how? If not, is there another method? Similarly, can you grab a comment or the cell color while using Vlookup? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup and hyperlinks
This worked for me where F1 is a link to another sheet cell A1 and holds a
lookup value for my table array on sheet 1. =VLOOKUP(INDIRECT(F1),A1:B3,2,0) The comment and color is a no, as far as I know. HTH Regards, Howard "wendy" wrote in message ... Is it possible to use Vlookup and grab the hyperlink from the cell? If so, how? If not, is there another method? Similarly, can you grab a comment or the cell color while using Vlookup? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup and hyperlinks
This worked for me where F1 is a link to another sheet cell A1 and holds a
lookup value for my table array on sheet 1. =VLOOKUP(INDIRECT(F1),A1:B3,2,0) The comment and color is a no, as far as I know. HTH Regards, Howard "wendy" wrote in message ... Is it possible to use Vlookup and grab the hyperlink from the cell? If so, how? If not, is there another method? Similarly, can you grab a comment or the cell color while using Vlookup? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Hyperlinks | Excel Discussion (Misc queries) | |||
Vlookup returning Hyperlinks | Excel Worksheet Functions | |||
Hyperlinks and Named Ranges | Excel Discussion (Misc queries) | |||
vlookup and email addresses | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions |