This section of free Excel Tips is a place to help you get tips and image assistant tools & utilities.
You can obtain Excel Picture LOOKUP in a long list of images or logos with the functions VLOOKUP, LOOKUP and INDEX / MATCH. This process is similar to looking for an image or values.
|I have a list of the 50 images with the name of the image and the image of the logo in the adjacent cell. The idea is to select an image name from the list and the image must be updated to show its correct image.|
It would be through the Excel add-in assistant of spreadsheet image tools.
From the following link, you can get the steps of how to create lock images in 3 clicks:
open Excel Image Vlockup dialog box in the Excel ribbon toolbar.
Select the list of image names and Columns and process images to create picture lists.
The tool will create a name for each set of images linked to the list. To access to the Excel name manager go to the ribbon tab formulas and click on the Group and open Names Manager dialog box.