Tom’s Tutorials for Excel: Putting a picture in a comment
Select comment and right click its edge.
Select Format Comment > Colors and Lines tab.
Click drop-down arrow of Color field in Fill section.
Select Fill Effects > Picture tab.
Click Select Picture button, navigate to your picture, click Insert > OK > OK.
Size comment as desired.
This article was a good read and learn. I have inserted images as comments with names while I was preparing Data in sheet 1 for the ID cards for my college. Now I want to perform lookup from sheet 2 on sheet 1 to create the ID card. All other details I have managed to lookup like roll number, name, father’s name, class, section, phone number, address with city name and zip code. These details were present in various columns on sheet 1. What I am not able to pull/lookup in sheet2 is the images which were inserted as comments in Sheet1. Can you help me with that.