Excel Magic Trick 1174

Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods)

DESCRIPTION

See three methods for lookup situations where you have two lookup values:
(00:10) What to do if you have two look values
(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
(02:03) IFERROR vs IFNA functions to hide error. See why new Excel 2013 IFNA function is better for array formulas.
(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
(05:41) MATCH and 2 INDEX functions in an array formula that does NOT require the special keystroke Ctrl + Shift + Enter
(07:30) VLOOKUP and CHOOSE functions in an Array Formula that requires the special keystroke Ctrl + Shift + Enter.
(10:31) DGET function and a proper database and a properly set up criteria area
(11:31) SUMIFS when you have two lookup values and you want to retrieve a number and there are no duplicate “Two Lookup Values”