|
Featured Tutorial
Featured Macro
Excel Magic Trick 625: INDIRECT SUBSTITUTE SUBSTITUTE Silly Two Way Lookup Formula
See an inefficient formula to do Two Way Lookup when the Named Ranges are different than the Data Validation Drop Down List items using the INDIRECT and 2 SUBSTITUTE functions.