Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Lookup Picture with Excel Formula – XLOOKUP or FILTER – Excel Magic Trick 1822

Posted on by Annie D

Download Excel File and zipped folder of pictures: https://excelisfun.net/files/EMT1822.zip
Learn about the new M 365 Excel Lookup Picture “Place In Cell” feature with allows you to easily insert pictures and then use the lookup functions XLOOKUP and FILTER to lookup pictures and to use pictures as lookup values.
Topics:
1. (00:00) Introduction
2. (00:22) Lookup picture with XLOOKUP
3. (01:05) Picture as lookup value in XLOOKUP
4. (01:29) Lookup picture with FILTER
5. (02:29) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp #xlookup #filter #filterfunction #lookup #picture

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

ExcelIsFunFri, June 30, 2023 2:10am