Lesson#106: How to lookup picture in excel

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.

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Tagged with: , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *