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!
Bookmarks