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!

bump back to the top...

Can anyone help?