ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Vlookup and hyperlinks (https://www.excelbanter.com/excel-worksheet-functions/84288-vlookup-hyperlinks.html)

wendy
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

L. Howard Kittle
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

L. Howard Kittle
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


All times are GMT +1. The time now is 10:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com