Deleted 

Look up values in a list of data

https://support.microsoft.com/en-us/office/look-up-values-in-a-list-of-data-c249efc5-5847-4329-bfee-ecffead5ef88?ui=en-us&rs=en-us&ad=us

LOOKUP function

https://support.microsoft.com/en-gb/office/lookup-function-446d94af-663b-451d-8251-369d5e3864cb?ui=en-us&rs=en-gb&ad=gb

Example:

What do I have to do so that I can click on the hyperlink in the formula cell and get to the appropriate place?

Formula:

=HYPERLINK("#"&SUBSTITUTE(VLOOKUP($A$4,'linktabelle!'!$B$1:$H$38,4,FALSE),"'",""),"Link to Site")

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.