Excel Magic Trick 881: Lookup Picture with INDEX & MATCH functions instead of INDIRECT Function

Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT881LookupPictureIndex.xlsx

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to do a lookup for Pictures in Excel using:
Data Validation Dropdown List
INDEX and MATCH Functions
Defined Names
Also see this video:
Mr Excel & excelisfun Trick 42: Lookup Picture In Excel Formula or VBA?:
Excel Magic Trick 637: Lookup A Chart -- Defined Names, INDIRECT function and Formulas In Pictures

Hint for Excel 2007: Excel Magic Trick 882: Excel 2007 Bitmap Image Lookup Picture INDEX & MATCH functions

Hint 2007: Use Bitmap Image instead of picture

Видео Excel Magic Trick 881: Lookup Picture with INDEX & MATCH functions instead of INDIRECT Function канала ExcelIsFun