Imagine I have a column H in which each row consists of a unique image URL which gets updated occasionally programatically.

Is there a way to apply a formula to each row containing the link? I wanna wrap =IMAGE("link_to_img.jpg") around it, but it needs to be dynamic so that the link can be updated dynamically.

CodePudding user response：

You would need a script for that.
Still. Since you tagged it under google-sheets-formula you can use a helper column and refer to the cell of the link.

=INDEX(IMAGE(H31:H35))

(Do adjust the formula according to your ranges)