Excel Forum



Excel Magic Trick 637: Lookup A Chart -- Defined Names, INDIRECT function and Formulas In Pictures


See how to lookup a chart using Defined Names, Data Validation List, and a formula using the INDIRECT function inside a picture of a chart. Select from the drop down list and your chart appears.
Related video: Mr Excel & excelisfun Trick 42: Lookup Picture In Excel Formula or VBA?





Got a Question? Ask it Here in the Forum.