Main Profile

At A Glance

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
Length: 08:19

Contact

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

Want more info about Excel Magic Trick #505: INDIRECT function 2-Way Lookup Date Trouble? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question