Hide Image/Object - Show when click on Relevant Cell

[PostTIT]

I'm making a table that has some info in various columns here and there, one of the columns I'm looking to use as a reference to some pictures and so it goes from 'Pic 1' to 'Pic 40' - currently just as plain text.

What I would like is either:

1. All the pictures on Sheet 2 and by clicking on the cell in sheet 1 then it takes you to the picture

2. By clicking on the cell in sheet 1 it opens the photo from the file explorer

3. I could put the photos online and clicking the cell opens the photos online

4. Clicking on the cell in Sheet 1 then just shows the picture - like when a cell has a comment attached the comment just pops up.


Basically I would like a method that doesn't require the photos to be on the same page as all the meta-data in the table (unless they can be hidden in some way).
Option 4 would be the most ideal to use for me and any help would be great.
I'm going to continue googling away to try and solve this but in the meantime help is always appreciated.

 

[Derek Brown]

You may find other solutions on YouTube but the following may be what you want:
Mr Excel & excelisfun Trick 42: Lookup Picture In Excel Formula or VBA? - YouTube

 

[PostTIT]

Thanks! That was what I wanted, but wrong edition of excel.

[Quick Tip] How to Insert a Picture in Excel Comment

Here's the one for 2016.

 

[Derek Brown]

You did not say what version of Excel you were using but I would expect the methods used to work for later versions of Excel with very few changes, if any.

 

[PostTIT]

Aye minimal changes, worked a treat, thanks!