Скачать с ютуб Excel Magic Trick 1174: Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods) в хорошем качестве

Excel Magic Trick 1174: Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods)

Download Excel Start File: https://excelisfun.net/files/EMT1174-... Download File: https://excelisfun.net/ See three methods for lookup situations where you have two lookup values: 1. (00:10) What to do if you have two look values 2. (00:36) Use Helper Column where we join the items in the two columns to create an additional Join Column. Then we can use VLOOKUP 3. (02:03) IFERROR vs IFNA functions to hide error. See why new Excel 2013 IFNA function is better for array formulas. 4. (03:16) MATCH and INDEX functions with the Ampersand (Join Symbol or Concatenation Symbol or Shift + 7) to create an Array Formula that requires the special keystroke Ctrl + Shift + Enter 5. (05:41) MATCH and 2 INDEX functions in an array formula that does NOT require the special keystroke Ctrl + Shift + Enter 6. (07:30) VLOOKUP and CHOOSE functions in an Array Formula that requires the special keystroke Ctrl + Shift + Enter. 7. (10:31) DGET function and a proper database and a properly set up criteria area 8. (11:31)SUMIFS when you have two lookup values and you want to retrieve a number and there are no duplicate “Two Lookup Values”