Generating urls in spreadsheet based on matching cells.

**giallofever** · 03-03-2009, 04:34 PM

Hi,

I am trying to create a spreadsheet for an online gift registry. They require that the spreadsheet have the photo's url's in a column. I already have the spreadsheet filled with my data. In the spreadsheet, Column D is filled with unique numbers, some with parenthesis, (ex. 52011, 52011(2), 34132, etc.) I also have a folder full of images that are similarly formatted as such
"...\images\brand_name_52011.jpg". (They will be moved eventually to a webserver.) Each number in the column may or may not have a corresponding image. And the images may or may not have a corresponding number in the spreadsheet. Is there a way to generate a url automatically in a column that corresponds to the image with the matching number? And if it doesn't, just leave it blank?

I found this and it seemed similar, but not the same.

http://www.excelforum.com/excel-misc...-url-list.html

I am completely new at this and don't know where to begin.

Thanks in advance,

Chris

**sarah.k** · 03-03-2009, 04:42 PM

the hyperlink function should do the trick? have you tried it?

**giallofever** · 03-03-2009, 09:23 PM

Originally Posted by sarah.k

the hyperlink function should do the trick? have you tried it?

I have tried it. The thing is, I want to create a link, and have part of the link reference a cell. Such as, the number in cell D5 is 43001, then the url in cell F5 should be,
"http://www.website.com/images/brand_name_43001.jpg", but I need it to be automatic or a script or batch file because there will be over 25,000 items and it will change as items come and go. But it will always be one spreadsheet and one images folder. Maybe subfolders

Thanks in advance.

**sarah.k** · 03-03-2009, 10:18 PM

I've got that happening in my sheet.

=HYPERLINK($A$1 & B2,"Page " & B2)

In this case A1 is static and B2 is an incremented number. I could build that link up in any number of ways, including user defined functions and strings.

**giallofever** · 03-05-2009, 11:47 AM

Originally Posted by sarah.k

I've got that happening in my sheet.

=HYPERLINK($A$1 & B2,"Page " & B2)

In this case A1 is static and B2 is an incremented number. I could build that link up in any number of ways, including user defined functions and strings.

Thank you, this got me real close to what I need. I will be making a new thread for my next issue which is related to the same spreadsheet and will send you a link to see if you can help me with that as well. Thank you so much for your help.

Chris

SOLUTION FOR MY PROBLEM

=HYPERLINK("http://www.website.com/registry_images/" & (C4) & "/" & (G4) & "/" & (C4) & "_" & (D4) & ".jpg")