I have a Google sheet with two worksheets.
- Worksheet A contains a big list of people with
- Worksheet B contains a small list with specific people and only
I would like to be able to add a link automatically for people in Worksheet B which can be identified in Worksheet A by
One entry in Worksheet B contains e-mail
email@example.com which can also be found in worksheet A (together with more information). In this case a column for this entry in Worksheet B offers a link to the entry in Worksheet A.