ExcelBanter - HyperLink

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - HyperLink (https://www.excelbanter.com/excel-worksheet-functions/133878-hyperlink.html)

Lloyd

HyperLink

Good Day My name is LLoyd

I have a list in one sheet, on the other I have Validation in a cell which
comes from a list, then below that =VLOOKUP($C$2,Database,5,0) in cells, but
my last Vlookup pick up a hyperlink, but it see it as text not a hyperlink.

Please Help

Thanks

Lloyd

Gary''s Student

HyperLink

Hi Lloyd

=HYPERLINK(VLOOKUP($C$2,Database,5,0))
--
Gary''s Student
gsnu200709

"Lloyd" wrote:

Good Day My name is LLoyd

I have a list in one sheet, on the other I have Validation in a cell which
comes from a list, then below that =VLOOKUP($C$2,Database,5,0) in cells, but
my last Vlookup pick up a hyperlink, but it see it as text not a hyperlink.

Please Help

Thanks

Lloyd

All times are GMT +1. The time now is 02:49 AM.