Excel Picture Lookup _ Step-by-step Tutorial
In this video you will learn how to use Image_lookup in Excel. You can use this technique basically anywhere where you need to show different images based on the value of a cell.eg product name employee name , product type employee pictures etc.
You'll also learn a few other techniques here. For example:
00:00 Introduction
01:48 How to work with Excel's picture tools (Crop images, Background color align etc.)
03:50 How to create Image_Lookup Tool
04:40 How to pull out the pictures into Image _lookup Tool
05:43 A little bit about the INDIRECT function(learn more with the below link)
08:28 How to use MATCH Function in Image_lookup to pull out the values Dynamically
10:30 How to use Name Manager to assign names to cells and how to do it quickly with "Create from Selection" option
11:50 How to use INDEX & MATCH Function to pull out the values from the database
14:31 How to pull the information from for the entire data
20:03 How to pull the values from the multiple image using "Offset Function"
👇Links to related videos:👇
Indirect Function • Excel INDIRECT Function _Free Excel Advanc...
Index & Match Function • Excel Index and Match Function - Complete ...
VLOOKUP Function • How to use COUNTIF and COUNTIFS Functions ...
You can also get this training and more resources here https://www.excelsirji.com
Please do comment if you have any feedback.
If you wanna support us and want us to write more. You can buy us a coffee from here:
https://www.buymeacoffee.com/excelsirji
Share the videos with your friends. Thank you
#MsExcel #Picture_lookup #exceltraining