Hyperlink vlookup?

[borak2k7]

Hey guys I imagine what I want to do requires VB work IF it can even be done.

We have a store database and these stores are indicated by number so store 1 - 5000 for example. We want a hyperlink to auto generate based on photos existing in a directory. For example in the photo directory we want the hyper link to display the photo "c:\Photos\1.jpg". store 2543 links to "c:\Photos\2543.jpg" etc.

Can anyone help?

[Dav]

do the list of stores exist in the excel spreadsheet in say a2:a2543

if so

=HYPERLINK("c:\photos\"&A2&".jpg") in say cell b2

or do you wish to generate the list from all the files in the directory, in which case some vba code is required. What do you need to do?

Regards

Dav