Lookup for pictures by picture number

[Ssaamirr]

Hello,

I wish to see picture of bottle in cell B9 "Katalog" sheet form "Slike vsebnikov" sheet by typing number in cell B7 "Katalog" sheet wich belongs to specific picture in "Slike vsebnikov" sheet.

I know it's possible and try to do by myslef but..

Tnx!

Katalog vsebnikov.xlsx

[Andy Pope]

See the Named formula, USE_PICTURE, which returns the correct address for the indirect function.

The image on the katalog sheet is linked to the USE_PICTURE named range