Download Files:
[ Ссылка ]
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
![](https://i.ytimg.com/vi/eMB_8VMmYmc/mqdefault.jpg)