Picture Lookup in Excel problem

Hello yjohari,

Maybe something as per the attached sample Workbook?

Regards.

You can replace indirect which is used here with index & match in name manager I just kept the picture column second


You need to first select the cell where you want to keep the pic lookup. Then go to insert select object and then select bitmap images. Now when bitmap is selected you can resize and in formula bar you can keep the defined name.

What I did
1)in A2 type Product In B2 Type Pictures In C2 Type Price and set the data.
i.e. Column A3 toA6 are Products. Column B3 to B6 are logos and Column C3 to C6 are Prices
2)Now select A3 to B6 then hold control and shift together and hit F3.
3)This will open a window "Create Names from Selection" select the second option which is left column.
4)Now go to name manager or Press Shift and F3 together click new in name box type any name like Pic_lookup and in the formula bar at the bottom copy paste =INDIRECT(Sheet3!$F$1)
5)Select E3 go to insert---> and click Object from object Menu select Bitmap Image. Once you click bitmap image it will insert a box. Then resize the box to fit in cell E3. When box is clicked go to formula bar and type =Pic_lookup.

Hello hemesh,

That is quite a good non VBA approach.

Regards

Thank you Sir

wladoD Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.