Using Vlookup pull a live Hyperlink

[salahuddin]

Dear all
Please help me find the formula to using vlookup to copy a live hyperlink

 

[xlstime]

Kindly share the some example.

Dear all
Please help me find the formula to using vlookup to copy a live hyperlink

 

[salahuddin]

IN SHEET I THE RAW DATA
SHEET2 IN CELL A3 WHEN I TYPE THE DESPATCH NO OF LOAN CASE CELL B3 RETURN THE HYPERLINK OF SHEET 1
PLEASE SEE

 

[Chihiro]

Something like below.
=HYPERLINK("#'Sheet1'!M"&MATCH(VLOOKUP(A3,Sheet1!$I$6:$O$66,5,),Sheet1!$M$6:$M$66,0),VLOOKUP(A3,Sheet1!$I$6:$O$66,5,))

 

[salahuddin]

Something like below.
=HYPERLINK("#'Sheet1'!M"&MATCH(VLOOKUP(A3,Sheet1!$I$6:$O$66,5,),Sheet1!$M$6:$M$66,0),VLOOKUP(A3,Sheet1!$I$6:$O$66,5,))

Something like below.
=HYPERLINK("#'Sheet1'!M"&MATCH(VLOOKUP(A3,Sheet1!$I$6:$O$66,5,),Sheet1!$M$6:$M$66,0),VLOOKUP(A3,Sheet1!$I$6:$O$66,5,))

 

[salahuddin]

dear Chiro
many many thnks to u.

 

[salahuddin]

Typing the formula below
=HYPERLINK("#'Sheet1'!M"&MATCH(VLOOKUP(A3,Sheet1!$I$6:$O$66,5,),Sheet1!$M$6:$M$66,0),VLOOKUP(A3,Sheet1!$I$6:$O$66,5,))

it goes to the cell where the hyperlink created.
will it possible to directly open the hyperlink page

 

[Chihiro]

I'm not sure that I understand. What do you mean by hyperlink page?

Is it URL (Web page), Worksheet... or something else?

 

[salahuddin]

sorry!!
typing the formula, it goes to the raw data page.
i want to open the file which i search.
in demo.xlsx, in sheet2 when i search something, i find the link in raw data in sheet1.
in sheet1 the hyperlink found which i search in sheet2 and then clicking the cell in sheet1 i could open the desire file.
But i want when i search something in sheet2 it shows the hyperlink in sheet1 of the respective data i search.