In this video, you will learn how to use Xlookup, Index/ Match, Index/ Xmatch and Vlookup functions to perform vertical and wildcard match based on multiple criteria. Please check out other videos on my channel and don't forget to like, share, subscribe and click the bell icon so you'll get a notification when the next video is uploaded. Thanks!
Content
00:00 Introduction
01:00 XLookup (Vertical lookup based on multiple criteria)
01:56 Index/ Match (Vertical lookup based on multiple criteria)
03:04 Index/ XMatch (Vertical lookup based on multiple criteria)
03:45 VLookup and IF Function (Vertical lookup based on multiple criteria)
05:46 XLookup (Wildcard match based on multiple criteria)
06:56 Index/ Match (Wildcard match based on multiple criteria)
07:31 Index/ XMatch (Wildcard match based on multiple criteria)
08:00 VLookup – Helper column method (Wildcard match based on multiple criteria)
Connect with me on:
👉Instagram and Facebook @youexceltutorials
👉Twitter @youexceltutor
👉LinkedIn @bunmisanusi
🎬Other relevant videos
XLOOKUP || INDEX/ MATCH || INDEX/ XMATCH || VLOOKUP (Intro) [ Ссылка ]
Multiple Criteria: XLOOKUP || INDEX/MATCH || INDEX/XMATCH || VLOOKUP -(Vertical & Horizontal Search) [ Ссылка ]
Vlookup, Match & Index Functions (Understand the differences and learn how to apply in a simple way) [ Ссылка ]
Excel Functions [ Ссылка ]
Try Microsoft 365 for free [ Ссылка ]
Download the file here - [ Ссылка ]
📢“Give thanks in every situation because this is God’s will for you in Christ Jesus.” (1 Thessalonians 5:18) CEB
#msexcel #youexceltutorials
