Vlookup (but with images)

[redJohn89]

Hi Guys is it possible to vlookup a value and return the image associated with the value in excel?


In my attached excel file i want to display the images of flags in Column B for corresponding values in col A.
Reference table is the "Flag Vlookup" tab.


Can this be done in excel?

 

[navic]

Display image based on adjacent cell data

Can this be done in excel?

Try see here or here or here.

 

[Hercules1946]

Crossposted here:

http://www.excelforum.com/excel-general/1147406-vlookup-but-with-images.html

 

[navic]

Vlookup images by named formula and display image based on text in adjacent cell

Hi Guys is it possible to vlookup a value and return the image associated with the value in excel?

One way. On this link describes the procedure for displaying image when it comes to one adjacent cell in which we choose the name of the image from the drop-down menu.

You need to repeat this action as many times as you have a cells to choice of name image.
You pay attention that I am named each cell in column 'A'.
After entering the name of the image respective is automatically displayed in the adjacent cell.

In the Name Manager you need to set for each cell of choice a single formula. So if you have 10 images, you need to enter 10 formulas in Name Manager.

'Pictures?' named formula

=OFFSET('Flag Vlookup'!$B$2;MATCH(DropDown;ChangePictures;0)-1;0)

'ChangePictures?' named formula
You also need to enter the following formula 10 times in the Name Manager.

=OFFSET('Flag Vlookup'!$A$2;;;COUNTA('Flag Vlookup'!$A$2:$A$12);1)

You pay attention that you need to change the arguments for each new formula.
See attached file.