Hi all

My first post on the forum and hopefuly not the last.

I've searched around and couldn't find what i need...


So heres what i need help with:


I've got X number of Sheets named Sheet1,Sheet2,...Sheet5

Sheet1:

A1 = a number
B1 = VLookup(A1;Sheet2!A1:B3;2)
C1 = Hyperlink to SheetX according to the number inserted on A1
Sheet2:

This is the example of matrix i have:

A1 = 3
A2 = 5
A3 = x

B1 = Hat
B2 = Plain
B3 = xxxx
So i really need help on Sheet1 C1 as above. I want that when i change the value on A1 the C1 changes the sheet it needs to go

Imagine:

A1 = 3 on C1 = Hyperlink to Sheet 3
So
If i put on A1 = 7 on C1 would show up the Hyperlink to Sheet 7

Or

AX = x on CX = Hyperlink to Sheet X
Well thats the best i can explain i guess...

Sorry for my bad english and the lack of experience on this subject.
Hope to get some help

Cheers