Dynamic Hyperlink from other cells

[lateraldesign]

Hi there

What would be the best way to create a dynamic hyperlink that could link to a local file/folder that is produced from the value of 2 or 3 other cells?

For example:

I want to create a hyperlink in cell A3 that links directly to the folder found at v://JOBS/AQUA/JamesBr

A1 has the value "AQUA"
A2 has the value "JamesBr"
A3 contains the link with the friendly name "Click Here"

Really not sure what the best way to achieve this would be?

Many thanks

[PFDave]

=hyperlink("v://JOBS/"&A1&"/"&A2,A3)

[PFDave]

Or sorry to actually do as you've asked:

Place this in A3

=hyperlink("v://JOBS/"&A1&"/"&A2,"Click Here")

[lateraldesign]

That's fantastic!
Works a treat.

Many thanks

[PFDave]

You're welcome,

If that takes care of your thread place can you mark as solved and add reputation where you see appropriate

Thanks

Dave