Excel - Can VLOOKUP Retrieve Images In Excel? - Episode 1485
Microsoft Excel Tutorial: How to Create a Picture Lookup in Excel Using OFFSET Function | MrExcel Podcast.
Welcome to another episode of the MrExcel podcast. In today's episode, we will be discussing a question sent in by Prince, who wants to do a lookup using either VBA, but instead of returning a value, he wants to return a picture. As always, if you have any questions for the podcast, feel free to shoot me an email at [email protected].
In this tutorial, we will be using the OFFSET function to create a picture lookup in Excel. First, we will insert the pictures into cells and make them fit completely inside the cell. Then, we will name the list of products on a separate sheet and create a dropdown list on the main sheet. Next, we will use the MATCH function to determine which item was chosen from the dropdown list. This information will be used in the OFFSET function to specify which picture to display.
To make the OFFSET function work, we will define a named range called MyPic, which will point to the heading of the list on the separate sheet. We will also use the OFFSET function to specify how many rows down and columns over we want to move from the starting cell. This can be a bit tricky, so make sure to pay attention to the details. Once the named range is defined, we can use it in place of the formula in the linked picture, resulting in the correct picture being displayed based on the chosen item from the dropdown list.
I hope you found this tutorial helpful and that it will save you time and effort in your future Excel projects. Don't forget to send in your questions to [email protected] for a chance to have them featured on the podcast. And be sure to tune in next time for another informative episode from MrExcel. Thanks for watching!
Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...
Table of Contents
(00:00) how to have lookup return a picture in excel
(00:32) Build a table of pictures in tall cells
(00:46) Vertical-align top
(01:26) Name the list
(01:39) Set up a Validation list
(01:51) Use MATCH to find which product matches
(02:13) Set up a placeholder picture with Paste Picture Link
(02:25) Assign a formula to the linked picture
(02:38) Store the formula in a name
(03:01) Using OFFSET function
(03:33) Replace formula in Linked Picture
(03:58) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelpicture #excelvlookup #lookup #xlookup
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
This video answers these common search terms:
how to have lookup return a picture in excel
vlookup return image in excel
excel vlookup with image result
insert picture with vlookup excel
display image based on vlookup result
can vlookup retrieve images in excel?
vlookup to display pictures in excel
link image to vlookup result in excel
dynamic image display with vlookup
excel formula to return picture with vlookup
show image based on vlookup value in excel
Prince asks if there is a way to return a Picture as the result of a VLOOKUP instead of a Value. In Episode #1485, Bill shows us one way to solve the challenge and deliver the result.
Watch video Excel - Can VLOOKUP Retrieve Images In Excel? - Episode 1485 online without registration, duration hours minute second in high quality. This video was added by user MrExcel.com 07 December 2011, don't forget to share it with your friends and acquaintances, it has been viewed on our site 32,121 once and liked it 124 people.