Vloggest Entertainment

Watch all your favorite videostars!
  • Share this video
  • facebook
  • Google+
  • Twitter
  • submit to reddit Reddit
  • Tags
  • Show tags

Which Lookup Formula is Fastest? Excel Magic Trick 1...

ExcelIsFun Follow
  • Video description
  • 12 months ago
  • 5,216 views
  • 339 likes
  • 87 comments
Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1631Part02TimeTwoLookupValueFormulas.xlsx
Charles Williams Timer: http://www.decisionmodels.com/FXLV4_Profiler_Beta1.htm
Time the 7 Two Lookup Value Lookup Formulas as seen in Excel Magic Trick 1631.
Formulas Timed:
1. OFFSET & VLOOKUP
2. INDEX & VLOOKUP
3. MINIFS
4. LOOKUP & FILTER
5. VLOOKUP & FILTER
6. XLOOKUP
7. LOOKUP & FILTER
Vlogger of the day:

KSI

"I had no clue on what I wanted to do when I was younger, so I was pretty lucky with this YouTube thing.” Olajide "JJ" Olatunji (born 19 June 1993), better known by his online pseudonym, KSI, is an...

read more

  • Comments
  • Related videos