Excel's NEW Lookup of Images
Excel
Jun 22, 2023 11:00 AM

Excel's NEW Lookup of Images

by HubSite 365 about Leila Gharani [MVP]
External YouTube Channel
Pro User

ExcelLearning Selection

Microsoft just released a new feature in Excel to insert pictures inside cells.

Excel's NEW Lookup of Images

Microsoft just released a new feature in Excel to insert pictures inside cells. It's called "Place in Cell". This allows us to create more advanced and professional-looking Excel dashboards without the need for complex solutions. Inserting images in cells makes it easy to use functions like XLOOKUP or FILTER to return an image. You can now also lookup a picture and return the corresponding information on the same row. So that pictures can be provided as a lookup value to lookup formulas like XLOOKUP. Availability: Microsoft 365 currently only in Beta Insiders channel.

  • 00:00 How to Insert Pictures Into a Cell in Excel
  • 00:32 Insert Images in Excel Cell
  • 02:20 Return Images With Formulas
  • 04:00 Bonus - Lookup Images
  • 05:58 Wrap Up

Microsoft Excel's Image Lookup Feature

The new "Place in Cell" feature in Microsoft Excel provides users with the ability to insert images into cells easily. This enhances the visual appeal and functionality of Excel dashboards, allowing for more customization and creativity. One major advantage of this feature is the capability to use functions like XLOOKUP and FILTER in conjunction with images, enabling users to return images with formulas or lookup pictures with corresponding data. Currently, this feature is available exclusively to Microsoft 365 Beta Insiders, but its potential to transform Excel workbooks and presentations is undeniable.

Learn about Excel's NEW Lookup of Images

Excel's new feature "Place in Cell" allows users to insert pictures into cells to create more advanced and professional looking Excel dashboards. This feature also enables users to use functions such as XLOOKUP and FILTER to return an image. Furthermore, images can be provided as a lookup value in XLOOKUP formulas. This feature is currently available in the Microsoft 365 Beta Insiders channel.

In order to insert pictures into a cell in Excel, users can click the Insert tab and select Pictures. They can then select an image from the computer or another location. Once the image is selected, it will be placed in the cell.

Additionally, users can use formulas to return images. For example, they can use the VLOOKUP function to match a key value with the image. When the formula is applied, the image will be returned.

As a bonus, users can also lookup images. This feature is useful when users need to return information corresponding to an image. For example, they can use the XLOOKUP function to match an image with the corresponding information.

In conclusion, Excel's new feature "Place in Cell" enables users to insert pictures into cells, return images with formulas, and lookup images. This feature is currently available in the Microsoft 365 Beta Insiders channel.

More links on about Excel's NEW Lookup of Images

Picture Lookup in Excel using Named Ranges
Learn how to use Named Ranges to do a Picture Lookup in Excel. This is a cool excel dashboard trick where pictures update dynamically based on selections.
Image Lookup - How-to show dynamic picture in a cell ...
Dec 16, 2020 — Learn how to show an image based on search criteria using Excel formulas. You can use Picture Links and simple formulas to make the images ...
Lookup Pictures in Excel
Feb 13, 2020 — This ability to lookup pictures is handy for returning images of products, employees, logos etc. The only limit is your imagination. In this ...
How to do an image lookup in Excel
Jan 18, 2021 — In this guide, we're going to show you how to make image lookup in Excel with XLOOKUP and INDEX-MATCH formulas.
How to Do a Picture Lookup in Excel
Jan 7, 2022 — Step 1: Create a table of the images you would like to use · Step 2: Setup the named ranges · Step 3: Creating another image for the lookup · Step ...
Picture Lookup in Excel
Until now, Excel doesn't have a lookup function that is designed to return a picture or pictures. That means there is no straight forward method for Picture ...
Lookup on Pictures in Excel
Jun 12, 2018 — Here's our Picture Lookup Challenge; Step 1: Organize the pictures in separate cells; Step 2: Assign Names to cells ...
VLookup to an image in excel
May 24, 2019 — Hello,. I want to create a sheet in excel that houses 2 columns of data: 1. 10 digit item code. 2. Photo of the 10 digit item code.
Create a Picture Lookup in Excel
Create a Picture Lookup in Excel · Click the Formulas tab on the Ribbon and then the Define Name button. · Enter a name for the defined name such as FlagPic ...

Keywords

XLOOKUP, Place in Cell, Excel Cell, Insert Images, Lookup Images