Excel Forum
Similar Content
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
Partial Match Lookup with Numbers in Excel
Tutorial: Perform lookups on numbers with partial matches. For instance, find the first number that...
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Mat...

Excel Magic Trick #505: INDIRECT function 2-Way Lookup Date Trouble

See how to use the INDIRECT, TEXT, SUBSTITUTE, Named Ranges, Create Name From Selection, and Space Operator to do a two way lookup when the named ranges contain dates. Then see a much better method using VLOOKUP and MATCH functions.
See this video:
Excel Name Trick #7: INDIRECT function, Names and LOOKUP

Got a Question? Ask it Here in the Forum.