=HYPERLINK(VLOOKUP(A1,lookup_table,2,FALSE),"mylin k")


Gord Dibben MS Excel MVP



On Fri, 12 Mar 2010 11:29:02 -0800, Spencer
wrote:

I am trying to use a Vlookup to pull a Hyperlink from a table, into another
cell. At this poing I cant seem to get the hyperlink to copy over as well. Is
there anyways that I can have this work?