+ Reply to Thread
Results 1 to 3 of 3

Add URLs based on number of images

  1. #1
    Forum Contributor
    Join Date
    05-29-2009
    Location
    Bloomington, Indiana
    MS-Off Ver
    Excel 2007
    Posts
    179

    Add URLs based on number of images

    Hello,

    Attached is an example sheet.

    Column A is number of images. Column B is the product ID. Column D is the URL I want to display.

    I want the URL to be domain_name/product id.jpg, but if there are multiple images, I need to have multiple URLs separated by commas. The second image will have "a" at the end of product ID, and the third image will have "b". So 3 images would be like this: domain_name/product id.jpg,domain_name/product ida.jpg,domain_name/product idb.jpg.

    How can this be accomplished? I thought about letting the URL column index a table (columns E & F) where xxx represents the product id, but xxx is a variable, and I can't get that to work in a table.

    Some products have a dozen images, so I'd like to avoid a really long if statement like

    =IF(A2="1","http://example.com/"&B2&".jpg",IF(A2="2","http://example.com/"&B2&".jpg"&",http://example.com/"&B2&"a.jpg","")) etc.

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    05-29-2009
    Location
    Bloomington, Indiana
    MS-Off Ver
    Excel 2007
    Posts
    179

    Re: Add URLs based on number of images

    bump back to the top...

  3. #3
    Forum Contributor
    Join Date
    05-29-2009
    Location
    Bloomington, Indiana
    MS-Off Ver
    Excel 2007
    Posts
    179

    Re: Add URLs based on number of images

    Can anyone help?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1