Explanation
The hyperlink function allows you to create a working link with a formula.
It takes two arguments:link_locationand, optionally,friendly_name.
The lookup value comes from column E, and VLOOKUP is configured for exact match.
The result is fed into HYPERLINK aslink_location, and the text in column E is used forfriendly_name.
HYPERLINK returns a working link.
you could use HYPERLINK to create a clickable hyperlink with a formula.
