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

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”

[ouarirou]

For this level of trick every watcher should give a thumb up

[orbtastic]

You saved me hours, I was going in circles trying to find how to do a multiple filter

[excelisfun]

Excel Magic Trick 1174: Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods)
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”

[edoldziey]

I must admit, I have been trying to accomplish what I thought would be a very intricate calculation, but this made it SO easy! LOVE this series of videos!!

[deninsrmic]

Brilliantly explained tutorial Mike with six different option to do LOOKUP. Many Thanks.

[ExcelStrategy]

It is incredible how many methods and techniques are concentrated in that 13 minuts video !

[donovancullum]

Wow, thank you so much! I've been searching for this for the past 6 hours but could not find out what to search. Nevertheless, this is such an ingenious and simplified way of teaching. Thank you

[krn]

Thanks Mike. You got your 'red' control shift enter text entered on the wrong lines 😊. I like the DGET formula, pretty cool.

[DIGITAL_COOKING]

When Computergaga pretended no one spoke about Dget function in late 2018, Mike presented function 3 years before!!!, great video specially i get solution for problem with different ways...keep going

[MikeDolanFliss]

Index-match with a helper I would have assumed... But Index-match-index to avoid CSE is pretty slick.  Thanks Mike!

[NewTascamUser]

I have a list: customers are listed multiple times with different service dates (in separate rows), some patients are listed with same dates, and each row has column value with yes/no; I'm trying to keep the row that has the "yes" value for each patient with the same date.
I appreciate your help

[IamMoreno]

Man you are really good im going to get a job because of your videos and your way to share your knowledge! thanks a lot.
Respect from Mexico

[adambooth]

Thanks.  It's great to see different calculation options

[TradShowTom]

I've learned a lot over the past few years watching your videos. Thank you. VLOOKUP was a game changer a few years ago for me. This new piece opens up some possibilities I haven't considered before. Thank you again. Do you have a similar series for Access?

[jhhocwo]

is there any videos or guides on the last step on SUMIFS onto VBA ?

[faisalfaisal]

How we make the “field (3)” on Dget function relative so when we drag the cursor right change to be 4, 5and so on…

[thomasdaniellife]

I have a question that I hope you can help with, I dont know if this is the formula that i need but maybe it is

[aleckkalonga]

Is there a formula when they's multiple look-up values and one table array?

[carlossegrera]

Sorry to bother you, but I need help. I'm trying to match 150 values to 130 values, Do you have a video that can help me. Basically, what I'm trying to do is to compare one column to another and see if the numbers from column # 1 are the same on column numbers 2, so I basically have to compare/match150 cells (Column 1) to 1 cell at the time on column number 2. Thank you for all you do and time and effort that you have given to help others.

[frankylan]

Can the first method work if the matrix/table is a defined name not manually selected?