There are many Excel functions (such as
VLOOKUP,
LOOKUP, INDEX/MATCH) that can go and fetch a value from a list. Imagine
doing the same, but instead of fetching a value, you can fetch a
picture.
In this tutorial, I will show you how to do a picture lookup in Excel.
It’s simple yet make you look like an Excel Magician (all you need is this blog and sleight of hands on your keyboard).
Picture Lookup in Excel
I have a list of the 20 teams in
English Premier league (ranking based on scores as of Nov 20, 2013) along with the club logo in the adjacent cell.
The intent is to select a club and the picture should change to display its logo.
Something as shown below: