Excel Index and Match Functions by Chris Menard

Показать описание

Use the Index and Match function to find a number across rows and down columns. The VLookup function will not do this.
You can replicate this video and follow up by just opening Excel and putting in the information shown.
Bookmarks:
00:18 - first Match Function
00:59 - 2nd Match Function
01:40 - Index Function
03:08 - Functions displayed on the screen
03:26 - Data Validation

I have two videos on Data Validation
Video on VLookup if you need to know when to use True vs False condition.

Chris Menard provides on-site Microsoft Office training to companies in metro Atlanta and the United States. He also does public speaking

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!