Hyperlink + Vlookup + If

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

Originally Posted by martindwilson

its quite convoluted to make a hyperlink like that! see attached you need a cell to create a reference to the sheet name i used H1

Thanks that did the job, i then used a Vlookup on the H1 Cell so that i would match my table

Very helpful :P