V look up a hyperlink

[Hayleh]

i'am trying to create a database which has all the information i need in sheet 2 and a cover sheet in sheet 1.

i have used V look up so that when i type in a location in a table on the cover sheet, all the information i need is brought from sheet 2 into the table.

the problem i have is that i have hyperlinked text in sheet 2 which takes me to a document, but in the cover sheet when i type in the location the text comes up but no hyperlink

does anyone know how to v look up a hyperlink?

[DonkeyOte]

Without knowing how the hyperlinks are stored on sheet2 it's hard to give a definitive answer but you might be able to get away with just embedding the VLOOKUP within a HYPERLINK function, ie:

=HYPERLINK(VLOOKUP(....))

[Hayleh]

This does make the look up a hyperlink but all the hyperlinks in sheet 2 link to individual documents and this brings up the same hyperlink

for example if i type in Sheffield in the cover sheet it brings up the text 'Fire Risk Assessment' for that property and the date the assessment took place. i want to be able to hyperlink to the actual assessment document specifically for Sheffield and so on for other locations

can this be done?

[DonkeyOte]

You're going to need to post a sample workbook - as is there's very little to go on...

[Chemistification]

I think this is what DonkeyOte was saying to do

[Chemistification]

Ah ok i get the problem. When you clik on the hyperlink it brings in it doesnt actually work... ok will have to have a think

[Hayleh]

Ive been told that i can use this

=HYPERLINK(VLOOKUP(E2,$B$2:$C$5,2,0),VLOOKUP(E2,$B$2:$C$5,2,0))
but i dont really understand how to use it, would this work?

sorry im new to using the vlookup function