Vlookup and hyperlinks

W

wendy

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

L. Howard Kittle

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
 
L

L. Howard Kittle

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
 
Top