Link one worksheet to another worksheet in same workbook

[kaleonard08]

Thank you in advance for your help.

My problem is trying to set up a link from one worksheet to another in the same workbook. I know how to set up a hyperlink and link it to a specific cell. However, I need more than just a specific cell.
The EVENTS worksheet (Worksheet1) has a list of schools in Column F (F9 is the header) and I need the hyperlink to be in column N (N10 is the first cell under the header) that links the school in Column F (Worksheet1) to the school in column A in the More Info (worksheet 2) worksheet.

The issue is column F on worksheet 1 has multiple lines for some schools and other schools only have 1 line. I cannot just link the cells with a simple formula. I want to set up a formula that finds the school in column F on worksheet 1 to the schools in column A in worksheet 2 and have a link in column N on worksheet 1 that will automatically take me to the school in worksheet 2.

I know this may be a little hard to understand but any help or suggestions would be greatly appreciated.
Thanks!