Hi there, can I change the value of a cell with an image adrress, lets say I have in A1 the Value “Pic1” and in B1 the address is “C:\localimages\picture1.png”, so if I change A1 to “Pic2” I want to change automatically B1 to “C:\localimages\picture2.png”,and so on with “Pic3”, “Pic4”, etc.
Is there a formula to do it like and If-Then-Else?
Thanks…
It would be much easier to put picture1 in to cell A1 and to have ="C:\localimages\" & A1 & ".png" as formula in B1
(or course formula ="C:\localimages\" & LOWER(REGEX(A1;"^[:alpha:]+")) & "ture" & REGEX(A1;"[:digit:]+$") & ".png" would turn Pic1 to C:\localimages\picture1.png, but looks too complicated to me).
Remark: If…then…else would be a poor thing since this would require to add all possible relations into one single formula. Then you could edit a separate table and use a VLOOKUP or a MATCH / OFFSET combination as well.