Hi,

I'm having this problem with showing the given image fully instead only partly. (See picture belowe)

Screen Shot 2019-06-13 at 19.30.58.png
Based on the name in D1, the below image change accordingly by using the formula: =INDEX(Sheet1!$B$1:$B$3;MATCH(Sheet1!$D$1;Sheet1!$A$1:$A$3;0))

As you can see only the left top corner is taken with the "Define name" formula, although the original picture is perfectly centered within the cell.

Any tips how I can solve this?

The ideal result should be like this:

Screen Shot 2019-06-13 at 19.33.53.png

Thank you