Thread: Creating a dynamic hyperlink by matching a value

I'm a day-0 newbie as far as the more advanced functions of excel go, so please forgive my lack of understanding. I have been crawling the internet for the past several hours looking up all the various functions of excel to figure out what I'm trying to do, including many on this forum, but I've never used any of them before and can't figure out how to get what I'm trying to accomplish. Maybe someone here can help. I've been looking at the HYPERLINK, VLOOKUP, MATCH, INDIRECT, INDEX, and ADDRESS functions, but still can't get it.

I want to make a simple excel workbook with two worksheets, and each sheet will have two columns. The first column is for a number, and the second is for text. So:

1 Text
2 Text
3 Text

I would like to be able to fill out the first worksheet (or have the numbers already filled out), and have each number become a hyperlink to the corresponding number on the 2nd worksheet, no matter where it is.

So that if WS 1 is

1
2
3
4

Clicking on the number 4 will take me to the number 4 on WS 2, even if it looks like:

18
7000
4
65

There won't be any repeating numbers.

Can anyone walk me through how I could do this?