Lookup Images in Microsoft Excel


This video explains how to use the Indirect function and the DGet function to lookup images and data in an Excel sheet. The tutorial covers how to use named cells and ranges, also how to use data validation lists.

Training courses are available at https://www.itseasy.co.uk/courses/excel-training/ courses can be delivery onsite or at our site in Gateshead. Online courses are available at http://www.itseasytraining.co.uk We have laptop which are available to use at your site and convenience. Call or email steve@itseasy.co.uk Business Mobile 07966503354

Lookup Images

The process in this video starts off explaining named cells and ranges, each photo sits inside a named cell. The tutor explains how to create a data validation list that displays the names of the photos. The indirect function is added in the name manager to reference the data validation box.

Indirect

The Indirect function is added to the name manager, by selecting new and creating a name. The Indirect function returns data from a referenced cell, in this case the image.

Images

Any of the images in the data set can be copied and placed in the relevant location on the lookup sheet. With the image selected the tutor explains that the formula must be typed using the Indirect name, (Flag) in the video example.

DGet

The DGet function is used to bring the remaining data across using the Data Validation list as its trigger. The DGet function works in a similar way to a Lookup working with a database of information.

I think that the best uses of these functions is in a catalogue of stock or parts. The parts or stock could have a photo which would be returned as and when required along with all the other data normally associated with lookups. Check out our YouTube channel at http://www.itseasytraining1st for more videos like this. Feel free to ask questions or ask for more videos.






Leave a Reply

You must be logged in to post a comment.

Testimonials


“Steve delivered a number of Microsoft Office Training Sessions to a range of employees across Newcastle College. The service provided by Steve is second to none. I have no hesitations in recommending him to other employers.”

Christine Jackman
Learning Manager(North) - Winner of Training Programme of the Year NECCA




“Steve’s background in IT training clearly provided him with great organisational and managerial skills which he put to good use at Second Chance Enterprises. His ability to see the long term strategy as well as manage the day to day management is one of his biggest strengths.”

Chriss Graham
Project Coordinator at Daisy Group




“I studied with Steve when we completed our CiPD CTP together. During the course I found Steve to be very personable and also very professional.  Steve was first on my list of suppliers. Steve was very competitively priced and very accommodating.”

Simon Snowdon
European Training Manager at HP Enterprise Services




“The course was really thorough and Steve was very knowledgeable and explained things very well. I’ve not used Microsoft Project before but now I feel very confident that I’ll be able to use it for what I need to do in my job”.

Craig Forster
Estimator, John F Hunt Regeneration Ltd