Thread: lookup function & hyperlinks

Hi,

I have a excel sheet which contains approx 150 location names. These all have hyperlinks which lead to different folders on our server. THe spreadsheet acts as an index.

What I wanted to do was use a lookup formula as opposed to having to spend time searching through the list, however when I set up the formula it finds the approriate location name within the spreadsheet, but it does not carry the hyperlink into the search result.

Is there anyway I can actually do this?

Thanks

Hi

Basically I wanted to have the lookup as a search option on a front page of the spreadsheet, then all the data is on another page of the spreadsheet.

I wanted the hyperlink to be pulled up on the result box (so you don't have the plough through the long list) . The important part is getting the link to an easy position (i thought a lookup formula would be easiest)

I don't know how to use vba, can you point me towards a good basics tutorial.

Ta