Forum Discussion
Excel dynamic lookup image keeps duplicating itself - but the cause was because of array formula
I made a file using dynamic images to display an image based on another cell value. I used the method described in this video: https://youtu.be/wlW2UKml9CY Instead of a drop-down name picker, the dyn...
yonghanwu Downloaded your file, removed the duplicate pictures. Changed nothing in the formulas or named ranges. Hence the dynamic array formula in D3 remains unchanged.
Pressed "Calculate now" many times. No duplication of the pictures occurred. Tested on both PC and Mac.