My sheet has part numbers cross referencing oem number, and the part number i look up has a comment with the picture of the part. I'm currently using vlookup to pull info when cross referencing. i would like the comment with picture to come with it. ideally hover over cell with formula and see picture but if i could get picture show in cell next to it that would be fine too. I've been trying to look into creating a custom function but have gotten no where.
Thank you
You cannot lookup a picture with a VLOOKUP, but you can do some clever things to get around that.
http://www.excelvlookuphelp.com/can-...urn-a-picture/
The named range works if you have a FEW pictures, but if you have a lot, I would likely do something else.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
free of charge
tim201110, could you please explain how you got the picture to change? I'm having trouble replicating it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks