Picture LOOKUP (Image Lookup) in Excel using Formulas

In this video, you will learn how to LOOKUP a picture /image in Excel.

While there are functions in Excel (such as VLOOKUP, HLOOKUP, INDEX/MATCH) to lookup and fetch a value from a list, to do a picture lookup in Excel, you need to use a little bit of workaround.

This would involve the lookup formulas as well as named ranges.

To do a Picture lookup in Excel, you need to have the images and use named ranges to fetch it.

I take an example of the football clubs from the English Premier League to show you how the logo appears when you select the club's name from a drop-down.

There are four parts to creating this picture lookup in Excel:
1) Getting the data set ready.
2) Creating a drop-down list to show item names (club names in this example).
3) Creating a Named Range
4) Creating a Linked Picture.

Picture lookup (Image lookup) technique can be useful when you have a list of products with names (or list of companies with logos) and you want to quickly select one of the products and want the picture to update automatically.

This can also be a really cool lookup technique when you're creating dashboards. You can make a selection change and as soon as you do it, the entire dashboard updates including the images/logos in it.
You can read more about this tutorial here: https://trumpexcel.com/picture-lookup/

⚡ Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos - https://www.youtube.com/c/trumpexcel

📌 This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website).

This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc.

⚡ Please subscribe to this channel to be the first to know when new Excel tutorials come out - https://www.youtube.com/c/trumpexcel

You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/

Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/

⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

Видео Picture LOOKUP (Image Lookup) in Excel using Formulas канала TrumpExcel