How to Select Images by Selecting Dropdown Text | Better Sheets Members Ask

🕰️ Time Saving Tips, Tricks and Techniques

🤖 Add AI to Your Sheets

🚀 Tools and Templates For YOU:

Generate Google Sheets Formulas:

100 Free Business Ideas - Lead Magnet, product, and business ideas you can make in a Google Sheet to validate your business ideas.

Tiny Sheets - Easily delete unnecessary rows and columns

Sheet Styles - Change your spreadsheets style to match your mood.

Atomic Sheets - 100 Spreadsheet elements you can add to your spreadsheets immediately.

Generate REGEXMATCH formulas to clean data

Generate SPARKLINE formulas to make cool charts inside of cells.

😎 Most Popular Tips and Tricks

Extract Urls from Google Sheets

⚙️Automate Your Sheets:

Spreadsheet Automation 101, get started making your sheets work for you, while you sleep

Learn to Code in Sheets - A quick course to get you started on Apps Script. Coding in sheets makes automating your sheets so much easier!

📺Step-by-Step Tutorials

Disclaimer: Some of these links go to one of my websites and some are affiliate links where I'll earn a small commission if you make a purchase at no additional cost to you.

[tracyisaacson]

Thank you for this post. I wanted to try to create a puzzle for my Chemistry classes using google sheets, but I was having so much trouble getting the dropdown menus to work with the images of the questions that I had made from slides. This was so clear and helpful, after I did it step by step, it worked!

[GiTristao]

Thank you for your classes! I never used google sheets before and I am getting make a mood tracker:)

[theoryoferin]

I'm wondering if there's a simple way to do this with multiple drop downs? For example, I have a table of characters and pictures of facial expressions based on their emotions. I'd like to have one drop down to select a character, a second drop down to select an emotion, and then based on those two choices, it would display the correct portrait for that specific character?

I feel like I'm on the cusp of figuring it out with dependent drop downs, but I can't quite get there. Thanks in advance for any help! :)

[gerardmasse]

Get rid of text on your video ... we cannot see what you are clicking ON