Download Excel Start File [ Ссылка ]
Download file: [ Ссылка ]
See how to do:
1. Two way lookup where one lookup is sorted ascending and the second is sorted Descending
2. Use MATCH with 3rd argument -1 for table sorted Descending
3. Lookup when there are more than one table using CHOOSE function and the Four Argument INDEX function.
Ещё видео!