Change an image from a cell value in Excel
In this video tutorial, I'll explain how to change an image based on a cell value.
We'll use a dog breed database as an example.
🔔 Subscribe and click the bell to stay up-to-date on the channel's news.
/ @planillaexcel
CONTENT
In the first part of the video, we'll see how to insert images into Excel and adjust their size so that they're exactly the same as the cell size. This is an important step.
In the second part, we'll create a drop-down list that displays the different values we can choose from.
Finally, we'll use the INDEX+MATCH function to display the associated image based on the value in the drop-down list.
CHAPTERS
00:00 Introduction
00:29 Step 1: Insert all the photos into the database (and arrange them!)
03:18 Step 2: Create the drop-down list with the dog breeds for the query
04:12 Step 3: INDEX and MATCH to retrieve the photo
07:05 Step 4: Assigning the created formula to the photo
07:56 Clarification: the image must cover the entire cell
RESOURCES:
✅ Practice with the template used in the video:
https://www.planillaexcel.com/blog/ca...
✅ Do you want to know how to retrieve the related information for each breed?
• BUSCARV en Excel
✅To create the breed drop-down lists, we use data validation:
• Listas desplegables en Excel
=============================================================================
📚 Register for my FREE Excel Masterclass
https://www.planillaexcel.com/clase-e...
===================================================================================
🎓Do you want to master Excel? Learn step by step with my course
https://www.planillaexcel.com/cursos/...
==================================================================================
🔔 Subscribe and press the bell to find out about channel news
/ @planillaexcel
Find and download more free templates at: www.planillaexcel.com
👪 Follow us on our social networks:
►Facebook / planillaexcel
►Twitter / planillaexcel
► Instagram / planilla.excel