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

Download Excel File:
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.

Excel,Highline College,Mike Girvin,excelisfun,excel is fun,excel fun,Excel Magic Trick 1631,EMT,EMT 1631,Two Lookup Values for VLOOKUP,2 Lookup Values for VLOOKUP,Two Lookup Values,Lookup to Multiple Tables,VLOOKUP Function,vlookup formula,OFFSET Function,INDEX Function,FILTER Function,LOOKUP Function,MINIFS Function,lookup formula,multiple lookup values,aeronautics lookup formula,Climb Speed,Density Altitude,Rate of Climb,