Action Packed XLOOKUP Video: 3-Way Lookup, Cell Reference Lookup, Conditional Formatting. EMT 1695.
Download Excel File: http://excelisfun.net/files/EMT1695.xlsx
Jam Packed Video with 3-way lookup, XLOOKUP function to lookup cell reference, and complex logical formula for three way conditional formatting.
Topics:
1. (00:00) Introduction.
2. (00:18) Why we need to lookup a cell reference.
3. (00:56) First XLOOKUP
4. (01:25) Colon Operator and second XLOOKUP.
5. (02:28) Third XLOOKUP to complete 3-way lookup.
6. (03:18) Old School formula using INDEX and MATCH functions.
7. (04:08) Conditional Formatting for 3-way lookup using the AND, COLUMNS and XMATCH functions and Mixed Cell References.
8. (09:05) Summary, Closing and Video Links
Видео Action Packed XLOOKUP Video: 3-Way Lookup, Cell Reference Lookup, Conditional Formatting. EMT 1695. канала excelisfun
Jam Packed Video with 3-way lookup, XLOOKUP function to lookup cell reference, and complex logical formula for three way conditional formatting.
Topics:
1. (00:00) Introduction.
2. (00:18) Why we need to lookup a cell reference.
3. (00:56) First XLOOKUP
4. (01:25) Colon Operator and second XLOOKUP.
5. (02:28) Third XLOOKUP to complete 3-way lookup.
6. (03:18) Old School formula using INDEX and MATCH functions.
7. (04:08) Conditional Formatting for 3-way lookup using the AND, COLUMNS and XMATCH functions and Mixed Cell References.
8. (09:05) Summary, Closing and Video Links
Видео Action Packed XLOOKUP Video: 3-Way Lookup, Cell Reference Lookup, Conditional Formatting. EMT 1695. канала excelisfun
Excel Highline College Mike Girvin excelisfun excel is fun excel fun excel magic Excel Formulas Excel Functions formulas and functions Excel Magic Trick 1695 EMT EMT 1695 Conditional format Excel conditional formatting 3-way lookup three way lookup XLOOKUP function Lookup cell reference AND function COLUMNS function Logical Formula for conditional formatting XMATCH function INDEX function Colon Operator 3 lookup values Lookup range of values
Комментарии отсутствуют
Информация о видео
13 октября 2020 г. 21:33:53
00:09:38
Другие видео канала
