Download Excel File: [ Ссылка ]
See three formulas to lookup nth value:
1. (00:00) Introduction
2. (00:32) Formula #1: Microsoft 365 with INDEX and FILTER functions.
3. (01:31) Formula #2: Excel 2010 or later: AGGREGATE, ROW and INDEX functions.
4. (03:47) Ctrl + C, C copy trick.
5. (04:10) Formula #3: Any version of Excel: SMALL, IF, ROW and INDEX functions.
6. (05:13) Summary, Closing and Video Links

свернуть