Lookup Picture Using Formula Without Using VBA

[mahmoud-lee]

Lookup Picture Using Formula Without Using VBA

[Excel Fox]

surely you can follow this

McGimpsey & Associates : Excel : Display picture based on cell value (http://www.mcgimpsey.com/excel/lookuppics.html)

[mahmoud-lee]

That's great, but I need it by the formula

[Excel Fox]

Check post # 3 in http://www.excelfox.com/forum/f2/select-group-of-cells-using-data-validation-1074/

The first sheet in the attachment uses a formula to display picture depending on selection in the validation list.