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.
• Excel Vlookup showing false and true ...
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 --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
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!
Watch video Excel Index and Match Functions by Chris Menard online without registration, duration hours minute second in high quality. This video was added by user Chris Menard 12 September 2016, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,80 once and liked it people.