How to display an image thumbnail from a hyperlink in a cell?

[DSmi5th]

I have a "Master" sheet that contains records for the antiques we buy and sell. One of the items in each record (C4:C100) is a cell containing a hyperlink to a local photo of the item. I use VLOOKUP in another data entry sheet called "Sell" to locate an item (By item #) and display the info for just that item. One of the cells in that sheet (D9) has the formula =IF(D5="","",VLOOKUP(D5,Master!A4:G217,3,0)) in it which returns and displays the hyperlink text. I am trying to find the right code that would display a sized image of the hyperlink on the Sell sheet.

Macis V1.2.xlsm
	A	B	C	D	E	F	G	H	I	J
1	Master Inventory / Sales Ledger			2022
2
3	Item #	Description	Photo	Purchase Date	Vendor	Purchase Price	Projected Sell Price	Sell Date	Sell Price	Customer
4	1	Water Meter	file:///Users/davesmith/Pictures/Photos Library.photoslibrary/originals/F/FF57B594-126C-4CD2-AE33-FC50C7AF530E.heic	2/1/22	Goodwill	$20.00	$30.00	1/23/22	$122.00	Flo
5	2	Pie	Pie	2/1/22	Magic	$12.00	$20.00	2/28/22	$33.00	Harry
6	3	Jeep	Jeep	1/3/22	Bud's Stuff	$11.00	$33.00	1/23/22	$44.00	****
7	4	Mat	mat	2/2/22	Goodwill Industries	$1.00	$12.00	2/28/22	$12.00	city
8	5	Steak	Steak	1/2/22	Bud's Stuff	$33.00	$55.00	3/23/22	$55.00	harry
9	6	Pool Tester	Pool Tester	1/4/22	Goodwill Industries	$11.00	$33.00
10	7	Hose	Hose	1/23/22	Bud's Stuff	$1.00	$4.00
11	8	Desk	Desk	3/3/21	Bud's Stuff	$3.00	$6.00
12	9	Dogs	Dogs	2/2/22	Bud's Stuff	$3.00	$55.00	1/23/22	$44.00	Bud Jones
13	10	Forklift	../Pictures/Idaho Forklift.jpg	1/4/22	Magic Treasures	$222.00	$333.00
14	11	Generator	Generator	2/1/22	Bud's Stuff	$45.00	$65.00
Master

Cells with Data Validation
Cell	Allow	Criteria
E13:E14	List	=ShortName
E4:E5	List	=ShortName
F6:F14	List	=ShortName

HERE IS THE SELL SHEET:

Macis V1.2.xlsm
	A	B	C	D	E	F	G	H	I	J
1
2
3		Sales Data Entry
4
5		Item #		4
6
7		Description		Mat
8
9		Photo		mat
10
11		Date Sold		1/23/22
12
13		Sell Price
14
15		Customer / Venue
16
17
18
19
20
21
22
23
Sell

Cell Formulas
Range	Formula
D7	D7	=IF(D5="","",VLOOKUP(D5,Master!A4:G217,2,0))
D9	D9	=IF(D5="","",VLOOKUP(D5,Master!A4:G217,3,0))

Cells with Data Validation
Cell	Allow	Criteria
D10	List	=LocationList
D11	Whole number	between -50000 and 50000
D15	List	=Customers!$B$4:$B$547

I hope I did this right, and thanks.

 

[DSmi5th]

I found another post that has given me enough to figure this out. Thanks to EdMitchell:

Hover over cell to display a NON comment dynamic external image

Hello All, I have seen a few things referencing a comment and filling it with a picture, but that unfortunately isn't dynamic. Then I have seen some outdated vba code (just older posts on the web) showing a way to accomplish it, but not finding one that works. What I would like to do is define...

www.mrexcel.com