Okay friends here I will show you an interesting tricks about Excel. That is how to lookup picture in excel. We have learned looking up values from a table but looking up picture from table is little different.
Here in the above picture you can see that I am having a picture table between range A1:B7. I have given name for each of the picture. You must remember that each picture should be in a single cell and that should not be a merged cell.
In the G2 cell where I need to lookup the pictures, there I will put this formula =INDEX(Sheet2!$B$2:$B$7,MATCH(Sheet2!$F$2,Sheet2!$A$2:$A$7,0))
See putting this formula directly returns the null value. So we have to copy the formula and go to Formula>Name Manager
In the name manager click on the New button.
Name: Name of your choice to identify. Here I have given “Photos”.
Refers to: =INDEX(Sheet2!$B$2:$B$7,MATCH(Sheet2!$F$2,Sheet2!$A$2:$A$7,0))
See here a definition is ready for pictures.
Now copy a picture and paste in the cell where to lookup pictures. Here I have pasted in the G2 cell. Selecting the picture in G2 cell in the formula bar I have put =Photos
See in the above picture. Our work is almost done here.
For easy selection of names I have made a Data Validation(List)
So in this way you can lookup pictures in excel easily.