vlookup and hyperlink to a cell

[hben]

Hi guys, I have a question that I really need to resolve. I have read several similar topics, but I could not really get how to solve it.
So, i have a table with values in one sheet.
I create another table, in another sheet, which returns a value from the first table, using the vlookup function.
What I need is to create a hyperlink from the result of vlookup to that exact cell in the first sheet.

I am not sure if i explained it correctly, but if anyone got it, please help.
Thank you very much!

 

[T. Valko]

Hi guys, I have a question that I really need to resolve. I have read several similar topics, but I could not really get how to solve it.
So, i have a table with values in one sheet.
I create another table, in another sheet, which returns a value from the first table, using the vlookup function.
What I need is to create a hyperlink from the result of vlookup to that exact cell in the first sheet.

I am not sure if i explained it correctly, but if anyone got it, please help.
Thank you very much!

Something like this...

This is your lookup table:

Book1
	A	B
2	A	31
3	B	55
4	C	52
5	D	14
6	E	99
7	F	51
8	G	78
9	H	44
10	I	41
Sheet2

On Sheet1...

A2 = lookup value = C

Enter this formula in B2. This will be both the lookup formula and the hyperlink.

=HYPERLINK("#"&ADDRESS(MATCH(A2,Sheet2!A:A,0),2,4,,"Sheet2"),VLOOKUP(A2,Sheet2!A2:B10,2,0))

 

[hben]

That is exactly what I needed! Thank you very much for the fast reply, you saved me a lot of work!

 

[T. Valko]

That is exactly what I needed! Thank you very much for the fast reply, you saved me a lot of work!

You're welcome. Thanks for the feedback!