Create a Picture Lookup in Excel

Create a picture lookup in Excel. Display a picture dependent upon the contents of another cell.

In this video, we create a picture lookup so that when a country is selected via a drop-down list, the associated flag for the chosen country is returned from a list.

The video looks at inserting an INDEX and MATCH function into a defined name and then referencing it from a picture. This works around the problem that a VLOOKUP written into a cell cannot return a picture.

Find more great free tutorials at;
https://www.computergaga.com

** Online Excel Courses **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ► LinkedIn: 18737946
Instagram ► Instagram: computergaga1
Twitter ► Twitter: computergaga1

• #howto_style
• #microsoft_excel_software
• #picture_lookup
• #vlookup_picture
• #computergaga
• #index_function
• #index_and_match_picture
• #picture_vlookup
• #how_to_create_picture_lookup_in_excel
• #create_a_picture_lookup_in_excel
• #vlookup_picture_in_excel_cell
• #vlookup_picture_in_excel
• #vlookup_formula_for_pictures_in_excel
• #how_to_create_picture_lookup_in_excel_2007
• #how_to_link_picture_in_excel_using_formula
• #insert_picture_link_in_excel_cell
• #alan_murray
• #advanced_excel_tricks_and_tips