Substituting Values in Excel using the Index and Match Functions

3,102 views · Published 12 March 2015 · 12:32 · Indexed 14 October 2026

Channel: Dr. Todd Grande · 2015 · Education

Watch on YouTube

This video demonstrates how to substitute values in Microsoft Excel using the Index and Match functions.

More from this channel

• 27:55 Psychoactive Drug Usage by Disorder: An Overview for Counselors

  Dr. Todd Grande

  4,909 views · 28 November 2014

• 7:29 Transposing Arrays in Excel

  Dr. Todd Grande

  3,929 views · 29 March 2015

• 15:31 Substitute, Replace, and Find Functions in Excel

  Dr. Todd Grande

  368 views · 6 April 2015

• 9:28 Graphing a Frequency Distribution in Excel Using the "Histogram" Feature

  Dr. Todd Grande

  514 views · 25 May 2015

• 13:13 Conducting a T-Test using the T.TEST Function in Excel

  Dr. Todd Grande

  3,569 views · 14 June 2015

• 9:45 Converting Variables into Z Scores in Excel

  Dr. Todd Grande

  3,826 views · 25 June 2015

• 14:44 Creating and Interpreting Scatterplots in Excel

  Dr. Todd Grande

  1,388 views · 2 July 2015

• 8:02 Creating a User Defined Function to Convert Z Scores into T Scores in Excel VBA

  Dr. Todd Grande

  385 views · 7 July 2015