👉 Become an Excel Rock Star in just a few hours with our "Microsoft Excel - From Beginner to Pro" course: https://bit.ly/4gHGZy0
In this video you’re going to learn how to use the MATCH function in Excel to return the position of a value in an array of values.
I’ll show you how to do it using exact, next smallest or next largest matches and also how to use the MATCH function horizontally or vertically.
And if you want to know how to use the INDEX/MATCH function combination check out this video: • You're About to MASTER Excel's INDEX ...
⬇️ DOWNLOAD THE EXCEL FILE used in this video: https://bit.ly/46r2DBV
📰 JOIN OUR NEWSLETTER Join to get free Excel tips, tricks and exclusive course discounts:
🔔 SUBSCRIBE to this channel: / @mark-cunningham
⌚ TIMESTAMPS
00:00 Excel's MATCH Function for Beginners Made EASY
00:39 Vertical array
01:13 Exact match type
02:57 Less than match type
04:20 Greater than match type
06:53 No match type
08:02 Horizontal array
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚖ DISCLAIMER
Information provided in our videos does not constitute financial, taxation, legal, business or other professional advice. If you make a purchase through an affiliate link provided here we may receive a commssion. We do not accept any responsibility or liability for purchases made through third-party vendors, websites, or services. It is your reponsibility to review and understand the terms, conditions, and policies of third parties before making any purchases.
Watch video Excel's MATCH Function for Beginners Made EASY online without registration, duration hours minute second in high quality. This video was added by user Mark Cunningham 31 July 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 282 once and liked it 7 people.