Hello everyone. I have created a simple VLOOKUP formula to find data for me. Now I need to insert a picture in an other cell which is corresponds to the data the formula found. I have named the pics to the exact value of the data and saved all pics in a folder. What I want is when I enter the search criteria the formula find me the data and insert the picture with the same name as the data value and size it to fit cell. Anyone can help please?
As i assuming if enter name in one cell, then you required those picture in another cell. Right.
I have attach one file for your reference.
In this file in sheet2 i have name & message & name picture.
Firstly creat name manager listname : In refer to mentioned range as :Formula:
Please Login or Register to view this content.
and second is for picture :Formula:Please Login or Register to view this content.
In sheet1 : "A1" select name & accordingly to name in cell "B1" display name and in "B2" display picture.
In "B1" formula is simple vlookup.
Formula:Please Login or Register to view this content.
In "B2" formula which is given in name manager as :Formula:Please Login or Register to view this content.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks