Excel Forum
Similar Content
Insert and Manage Page Breaks in Excel
Tutorial: How to insert, remove, and manage page breaks in Excel.  This can be rather annoying and...
Convert Column Number to Letter Using a Formula in Excel
Tutorial: How to get a column letter from a number in Excel using a simple formula. This is an ...
Formula to Count Occurrences of a Word in a Cell or Range in Excel
Tutorial: Formula to count how many times a word appears in a single cell or an entire range in Exce...



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.