Excel Forum



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.





Got a Question? Ask it Here in the Forum.