Vloggest Entertainment

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

Excel’s # 1 Silliest Formula: INDEX or INDIRECT? Exc...

ExcelIsFun Follow
  • Video description
  • 1 year ago
  • 7,554 views
  • 386 likes
  • 102 comments
Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1571Start.xlsx
Download Excel Finished File; https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1571Finished.xlsx
In this video have fun with silly and inefficient formulas to do a Two-Way Lookup using: 1) the INDEXT and MATCH Functions and the Space Operator and 2) the Defined Name Feature, The INDIRECT Functions and the Space Operator. Both formulas are for fun because there are more efficient formulas as seen in these videos:
Excel Two Way Lookup with VLOOKUP & MATCH Functions - Excel Magic Trick 1567
https://www.youtube.com/watch?v=tbgmC2u-VfI
Excel Two Way Lookup with INDEX & MATCH Functions - Excel Magic Trick 1568
https://www.youtube.com/watch?v=TaLc6ZToY3Q
Vlogger of the day:

Dude Perfect

Dude Perfect is an American entertainment show focusing on extreme sport tricks aired on YouTube. The group has 4 members: twins Coby and Cory Cotton, Garrett Hilbert, Cody Jones, and Tyler Toney;...

read more

  • Comments
  • Related videos