Download Mr Excel & excelisfun Trick 7: Reverse Lookup VBA or Formula? video

Download Mr Excel & excelisfun Trick 7: Reverse Lookup VBA or Formula? video on savevid.com

Download Mr Excel & excelisfun Trick 7: Reverse Lookup VBA or Formula? streaming video in flv, mp4, avi formats direct easily on Savevid.com.

 

Mr Excel & excelisfun Trick 7: Reverse Lookup VBA or Formula?

  • Share:
                    
  • Provider: YouTube Link: http://www.youtube.com/watch?v=qD6hO53cRP4
  • Rate: Please rate this video Views: 12 Downloads: 19
  • Description: See Mr Excel and excelisfun complete a Reverse Lookup (find value inside table and then retrieve Column and Row header. Mr Excel uses Excel VBA code (Macro) and excelisfun uses a formula with INDEX, IF, SMALL, MATCH, TEXT, CHAR and COLUMNS functions.

    INDEX and MATCH magic
  • Tags: , , , , , , , , , , , , , ,
  • Category: Flag video Science & Technology