How to Do a Picture Lookup in Excel
Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-courses
Learn to quickly lookup images based on the value of a cell. Some people call this VLOOKUP on images. You can use this technique for company logos, employee pictures, flags - basically anywhere where you need to show different images based on the value of a cell.
⬇️ Download the workbook here: https://pages.xelplus.com/lookup-pictures-file
📊 What You'll Learn:
▪️ Dynamic Picture Lookups: Discover how to perform lookups on pictures, a unique and practical Excel feature.
▪️ Real-World Examples: Understand the concept through real-life examples, including a FIFA World Cup tool that updates country flags dynamically.
▪️ Step-by-Step Guide: Follow a detailed walkthrough on organizing images, formatting them correctly, and linking them to data.
▪️ Name Manager & Indirect Function: Learn to use Excel's Name Manager and the Indirect function to make image lookups dynamic.
▪️ Practical Application: See how this technique can be applied for various purposes, such as employee photos, sales manager pictures, or company logos.
You'll also learn a few other techniques here. For example:
1. How to work with Excel's picture tools (Crop images, align etc)
2. How to use Name Manager to assign names to cells and how to do it quickly with "Create from Selection" option
3. A little bit about the INDIRECT function (find out more with the below link)
4. How to link pictures to cells
★ Links to related videos: ★
World Cup 2018 Sweepstake (with free template link): https://youtu.be/a2IXn1FQU3A
INDIRECT function: https://youtu.be/GUClkvJ7Gag
Data validation basics: https://youtu.be/FRiFfKb_B_A
Custom Data validation: https://youtu.be/bDXQy60BcT4
➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: https://www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
Видео How to Do a Picture Lookup in Excel канала Leila Gharani
Learn to quickly lookup images based on the value of a cell. Some people call this VLOOKUP on images. You can use this technique for company logos, employee pictures, flags - basically anywhere where you need to show different images based on the value of a cell.
⬇️ Download the workbook here: https://pages.xelplus.com/lookup-pictures-file
📊 What You'll Learn:
▪️ Dynamic Picture Lookups: Discover how to perform lookups on pictures, a unique and practical Excel feature.
▪️ Real-World Examples: Understand the concept through real-life examples, including a FIFA World Cup tool that updates country flags dynamically.
▪️ Step-by-Step Guide: Follow a detailed walkthrough on organizing images, formatting them correctly, and linking them to data.
▪️ Name Manager & Indirect Function: Learn to use Excel's Name Manager and the Indirect function to make image lookups dynamic.
▪️ Practical Application: See how this technique can be applied for various purposes, such as employee photos, sales manager pictures, or company logos.
You'll also learn a few other techniques here. For example:
1. How to work with Excel's picture tools (Crop images, align etc)
2. How to use Name Manager to assign names to cells and how to do it quickly with "Create from Selection" option
3. A little bit about the INDIRECT function (find out more with the below link)
4. How to link pictures to cells
★ Links to related videos: ★
World Cup 2018 Sweepstake (with free template link): https://youtu.be/a2IXn1FQU3A
INDIRECT function: https://youtu.be/GUClkvJ7Gag
Data validation basics: https://youtu.be/FRiFfKb_B_A
Custom Data validation: https://youtu.be/bDXQy60BcT4
➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: https://www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
Видео How to Do a Picture Lookup in Excel канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
116 Excel Tutorials in 1 VideoMake better Excel tables: BMW report to the test (Part 3)The Secret to Making Hand-Drawn Charts in ExcelAre These Pivot Table Mistakes Costing You?How to Use Excel's NEW Lookup of Images 👉 Professional Dashboards Just Got Easy ➕ Bonus RevealHow To Use the new Excel TEXTBEFORE & TEXTAFTER Functions to Save Time on Your Next ProjectEffortlessly Create Dynamic Charts in Excel: New Feature Alert!Unusual use of Excel's Custom Number Formatting with Conditions & Symbols (Part 2)Why You NEED to know the Time Value of Money Formula (Excel NPV function)How to Use Excel's New TAKE Function to Impress Your Boss and ColleaguesCommon Excel Pivot Table Features People Miss (and you?)5 FREE Cool Add-Ins for PowerPoint to Start Using NOWHow Familiar Are You With Excel Cell Modes? (Ready, Enter, Point, Edit)Lookup Secrets in Excel: Easily Handle Upper & Lower BoundariesExcel Flash Fill For MAJOR Time Saving (7 Examples)You Won't Believe These Crazy PIVOT TABLE Hacks!How to Use TOCOL | TOROW Function in Excel #shortsExcel Features You NEED to KNOW (If you work in Accounting)The Secret to Note-taking for Busy PeopleEasiest Way to Edit Visuals in Power BI - Watch before using the new features (Includes hidden tips)How to Use SUMIFS with Partial Match and Wildcards in Excel