Two Lookup Values for VLOOKUP? See 5 Examples. Which is Your Favorite? Excel Magic Trick 1631.

What if we have an Exact Match Lookup Value AND an Approximate Match Lookup Value, and we need to use both to lookup a value? See these five examples:
1. (00:01) Introduction and discussion of issue at hand.
2. (00:45) Example 1: VLOOKUP and OFFSET Function.
3. (04:13) Example 2: VLOOKUP and INDEX Function.
4. (04:41) Example 3: VLOOKUP and FILTER Function.
5. (06:14) Example 4: LOOKUP and FILTER Function.
6. (07:05) Example 5: MINIFS Function.
7. (08:18) Summary and comments about which is your favorite : )

Great Explanation of how Excel OFFSET Function works. With Diagrams to visualize how OFFSET functions works. See a reference to the INDEX Function as a substitute for the volatile OFFSET function. Shows the amazing Office 365 FILTER Function. The FILTER function is really one of the new office 365 lookup functions. See multiple examples of the VLOOKUP Function. See how to use the seeming historic and out of date LOOKUP Function in a way that beats all the modern Lookup Functions. See how to use the MINIFS Function as a lookup function, when we have numbers as our retrieved lookup values.

[excelisfun]

Topics:
1. (00:01) Introduction and discussion of issue at hand.
2. (00:45) Example 1: VLOOKUP and OFFSET Function.
3. (04:13) Example 2: VLOOKUP and INDEX Function.
4. (04:41) Example 3: VLOOKUP and FILTER Function.
5. (06:14) Example 4: LOOKUP and FILTER Function.
6. (07:05) Example 5: MINIFS Function.
7. (08:18) Summary and comments about which is your favorite : )

[excelisfun]

Summary:
Great Explanation of how Excel OFFSET Function works. With Diagrams to visualize how OFFSET functions works. See a reference to the INDEX Function as a substitute for the volatile OFFSET function. Shows the amazing Office 365 FILTER Function. The FILTER function is really one of the new office 365 lookup functions. See multiple examples of the VLOOKUP Function. See how to use the seeming historic and out of date LOOKUP Function in a way that beats all the modern Lookup Functions. See how to use the MINIFS Function as a lookup function, when we have numbers as our retrieved lookup values.

[briandennehy]

Every day is a learning day on this channel, thanks Mike 👍

[Computergaga]

FILTER function of course because I'm giddy with excitement on that one. MINIFS was pretty cool though.

[rajenderkmr]

Sir, you just excellent. No word can define you.

[ashoksahu]

Waooo
This is so excellent video. You are great.

[deepakmirchandani]

great sir, i loved vlookup and offset combination. thanks for solving such typical problem by so many methods.

[abhishek]

Wow Awesome Sir I salute you
Because you are genius in excel
You are guru in excel.
Thank u so much Sir,
You are share valuable experienced with us.

[HusseinKorish]

The Bonus Formula and comparison between office versions is just perfect .... Thanks Mike

[matthewhart]

FILTER all day long. The new dynamic arrays have changed my life....so easy to use. I just can’t wait to they are available to all so others an benefit from these!

[johnborg]

Great staff!!!! Thanks mike. Filter was great. Index & match is fun to build too. :) :)

[harismuhammad]

Great video to learn advanced look up and offset function. Mike I'm very grateful to you for this video and Excelfun channel.

[kiwikiow]

I like FILTER + VLOOKUP / LOOKUP most. Hope FILTER will be released to everyone soon. I have never used OFFSET and MINIFS. Thank you Mike for tutorials :)

[MalinaC]

My favourites are MINIFS and VLOOKUP+Filter. I find them easiest for me to understand and explain :). Thanks for sharing!

[darrylmorgan]

FILTER Function seems the way to go!Really like the MINIFS Function pretty cool too!Thanks Mike :):)

[nsanch]

Good lookup examples! I would use VLOOKUP and FILTER because I'm most familiar with Vlookup and Filter only uses 2 arguments. When Filter is evaluated it returns that look-up array which I find easy to verify =VLOOKUP(F5, {-4000, 1155.46;-2500, 623.27;-1000, 601.29;500, 429.91;2000, 418.94}, 2). Thanks Mike.

[spilledgraphics]

MINIFS !? wow.... I liked that non-obvious solution Mike! :P

[sasavienne]

Just wowwww. Thank you for these amazing and powerful formulas Mike. 👍 🌟 🌟 Thanks

[barttitulaerexcelbart]

Thanks Mike. Amazing to see even LOOKUP as a major contributor...in stead of the maxif, you could use your famous ctrl-shift-enter variant. I wish you a good and healthy 2020. Looking forward to all new 2020 videos. Cheers Bart

[sevagbarsoumian]

Thanks Mike,
the lookup is the best one
:)