show an image according to cell content

[vermaccio]

i need to show an image according to cell content.
For every cell value shoud be shown a different image, taken from a collection in a sheet in the same excel file.

See attached file

note: i don't know if this can be made directly by formulas, but i think no.

thank you

[AliGW]

No, not possibloe with a formula.

[KOKOSEK]

Shortly..... Create named range with formula (ex. MyImage):

Please Login or Register  to view this content.

then paste picture where you want, select and in formula bar type:

Please Login or Register  to view this content.

Check attached file.

[vermaccio]

thank you! solved!

[vermaccio]

. ok all solved