A while ago, someone asked me "how to show an image dynamically based on user input?". In this video, let me show you what I call "VLOOKUP for images". This powerful trick lets you display employee photos, product images or other such things based on user input.
For a sample file & more discussion visit
https://chandoo.org/wp/excel-image-lookup/
for more about XLOOKUP, see this video - https://youtu.be/lndYovPxuw4
#ExcelTricks