How to Insert a Picture in a Cell ?
In B2 I have Product1 and in C2, picture of Product1
I have inserted picture in C2 location but how to associate it with cell C2
=index(c2:c10,match(a1,b2:b10,0)) dosn't give me the picture but the value of c2, which is 0
Last edited by ionelz; 02-11-2020 at 02:57 PM.
Images are not cell data. You cannot display an image from a formula like that. It might be possible to use a slightly complicated workaround to do what you want but we need more information. Please attach your sample file using the instructions in the yellow banner at the top of the page.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Thank you for response.
I have attached a file
I want to select in Data sheet at C2 and bring picture from Pictures sheet at E2
Enlarged if possible from E2 to M23
You can check the link below ...
https://trumpexcel.com/picture-lookup/
and, the procedure described in the above link is adapted to your file as seen in the attachement.
.
Last edited by Haluk; 02-12-2020 at 03:15 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks