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