Why replace VLookup with Index and Match in Excel

Channel:
Australia Magic Monk
Subscribers:
64,000
Published on ● Video Link: https://www.youtube.com/watch?v=6nX2pyUyc7Q


Duration: 6:31
219 views
8

In this video I want to talk about the Index and Match functions in Excel, so you know what they do and why they would be used to replace Vlookup!



Other Videos By Magic Monk


2020-11-05Excel Tutorial - FIFO Accounting Part 2 (First In First Out)
2020-11-02Screencasting using Microsoft Powerpoint
2020-10-30Excel Tutorial - FIFO Accounting Part 1 (First In First Out)
2020-10-27Left hand side bar not disappearing on full screen Youtube Video fix
2020-10-24How to close all Windows 10 Desktops
2020-10-21How to find your own videos in the Facebook app (Android)
2020-10-18Intermediate Green Route #7 Top Rope Rock Climbing filmed with Samsung Galaxy S10e
2020-10-15How to send yourself a message on Microsoft Teams Android app
2020-10-12Wheel falls off moving car in front of you on highway! 2020-09-18 4pm QLD Australia
2020-10-09How to message yourself on Microsoft Teams
2020-10-06Why replace VLookup with Index and Match in Excel
2020-10-03Can Mail Merge do multiple records on one page in MS Word
2020-09-30Is Freesync turned off for your monitor? (Xiaomi Mi Curved 34")
2020-09-27144Hz refresh rate monitor running at 50Hz?? How to fix! (Xiaomi Mi Curved 34")
2020-09-26Travel around Europe with Xiaomi Redmi 6 and DJI Osmo Mobile 2 - Český Krumlov Episode 15
2020-09-25Travel around Europe with Xiaomi Redmi 6 and DJI Osmo Mobile 2 - Český Krumlov Episode 14
2020-09-24Unboxing / Review: Xiaomi Mi Curved 34" 144Hz WQHD 21:9 FreeSync Gaming Monitor
2020-09-24Travel around Europe with Xiaomi Redmi 6 and DJI Osmo Mobile 2 - Český Krumlov Episode 13
2020-09-21Unboxing / Review: Samsung 31.5 inch Curved 1920x1080 Monitor LC32F391FWEXXY
2020-09-18Microsoft Excel - How to extract just the Date from Date/Time cell
2020-09-15Bouldering Green Route @ Brisbane Rock Climbing Gym Urban Climb Milton