Hyperlink & Vlookup formula

[kapi98]

Hi there,

Would it possible for this type of formula to return value only when the relevant link is provided in the source table? I mean when there's no link in the identified cell the cell remains blank.

=HYPERLINK(VLOOKUP(B207,Table1,4,FALSE),"IMAGE")

Many thanks,
Kapi

[bebo021999]

I tested in attachment and it works for me.

[kapi98]

Thank for your reply. In your example, would it be possible for the formula (C7) to return blank if we deleted link the link for option b (H3) and typed 'b' as our selection (B7)

[bebo021999]

May be try with IF

=IF(VLOOKUP(B7,E2:H4,4,0)="","",HYPERLINK(VLOOKUP(B7,E2:H4,4,0),"image"))

[kapi98]

Thanks for this suggestion. I'll give it a try and let you know if it worked