Pulling (or showing up) a picture based on cell value?

[expeo]

On worksheet 1, I have a list like the one below.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]List Number[/TD]
[TD]Address[/TD]
[TD]Picture[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]15[/TD]
[TD]44 Main St[/TD]
[TD]???[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]16[/TD]
[TD]39 Triangle Ave[/TD]
[TD]???[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]17[/TD]
[TD]961 Yellow Pkwy[/TD]
[TD]???[/TD]
[/TR]
</tbody>[/TABLE]

On worksheet 2, I have pasted pictures from a external source. The pictures are already named and ordered (but are increments of 2). So they correspond like below.

[TABLE="width: 500"]
<tbody>[TR]
[TD]List Number[/TD]
[TD]Image Name[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Picture 1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Picture 3[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Picture 5[/TD]
[/TR]
[TR]
[TD]...[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Picture 29[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]Picture 31[/TD]
[/TR]
</tbody>[/TABLE]

I cannot use any macros, is there anyway to use VLOOKUP or INDEX MATCH (or any other method) to somehow match and show pictures (for column C in worksheet 1) based on the pictures that are in worksheet 2?

 

[geo77]

It's trivial by using macros, but if you cannot use macros, I recommend that you display the the pictures on a 2D scatter chart. There are countless of examples like this used at : www.excelunusual.com.

Let's say, for the sake of argument that you have 3 pictures to display, depending the contend of cell A1 being 2, 4 or 6.

You create a scatter chart containing 3 points, and assign to each of the 3 marker points a picture (see video below). If the number in cell [A2] for instance is 2 (therefore you need to display the first image) you make the first data for point (x1,y1)=(0,0) and the following data points
(x2,y2)=(0,-99), (x1,y1)=(0,-99).


I've just made an example for you.
If you insert 2/4/6 in cell [A2] you can select between three different pictures. Try it out and let me know.

Watch the video tutorial and download the .xls file at: http://www.excelunusual.com/a-simple-tutorial-of-using-sprite-animation-on-a-2d-scatter-chart/

 

[geo77]

It's trivial by using macros, but if you cannot use macros, I recommend that you display the the pictures on a 2D scatter chart. There are countless of examples like this used at : www.excelunusual.com.

Let's say, for the sake of argument that you have 3 pictures to display, depending that the list number is 2, 4 or 6.
You create a chart containing 3 points, and assign to each of the 3 marker points a picture (see video below). If the number in cell [A2] for instance is 2 (therefore you need to display the first image) you make the first data for point (x1,y1)=(0,0) and the following data points
(x2,y2)=(0,-99), (x1,y1)=(0,-99).


I've just made an example for you.
If you insert 2/4/6 in cell [A2] you will display three different pictures.

Watch the video tutorial and download the .xls file at: http://www.excelunusual.com/a-simple-tutorial-of-using-sprite-animation-on-a-2d-scatter-chart/