Excel Forum
Similar Content
Prevent Errors From Appearing in Excel
Tutorial: How to prevent errors from appearing in formulas in Excel. This is especially helpful for...
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
Macro: This free Excel macro illustrates all of the possible parameters and arguments that yo...
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Ma...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Mr Excel & excelisfun Trick 42: Lookup Picture In Excel Formula or VBA?


See Mr Excel and excelisfun lookup a picture in Excel. See a VBA solution and a Formula Solution using the INDIRECT function and named ranges. See many tricks in this video:
1.Data Validation List
2.Hiding Text with formatting
3.Named Ranges
4.Keyboard shortcut for Naming Create Name From Selection
5.Keyboard shortcut for Pasting a Name
6.Insert A Comment
7.Format a Comment (click outer edge)
8.Insert Picture in Comment
9.VLOOKUP
10.VBA to lookup a picture
11.Keyboard shortcut for VBA editor
12.Defined Name Formula
13.INDIRECT function to convert text that represents a reference into a reference
14.Put a formula in a picture
15.Paste Special Linked Picture (Camera Tool)
16.Checking Defined Name accuracy with Collapse Button
17.More
How do I Lookup a Picture In Excel VLOOKUP Lookup picture in Database using Excel How do I use VLOOKUP to retrieve a picture





Got a Question? Ask it Here in the Forum.