Combining VLOOKUP and MATCH

Delayed 2 days

• Video 1

• Video 2

• Video 3

• Video 4

• Video 5

• Video 6

• Video 7

• Video 8

• Video 9

• Video 10

• Video 11

• Video 12

• Video 13

• Video 14

• Video 15

• Video 16

• Video 17

• Video 18

• Video 19

• Video 20

• Video 21

• Video 22

• Video 23

• Video 24

• Video 25

• Video 26

• Video 27

• Video 28

• Video 29

• Video 30

• 4 Ways To Get Better At Excel Today! (THE EXCEL METASKILLS)

• How Do Companies ACTUALLY Use Excel In 2023?

• Excel Simplified: The Things You NEED To Know In Excel (and what you can ignore)

• How To Collect Data With Excel In 2023 (Without Annoying Your Coworkers!)

• Power Query For Beginners

• STOP Fixing Data In Excel! START Using Excel Data Validation Like A Pro ...

• Top 10 Excel Formulae For Cleansing Your Data QUICKLY And EFFICENTLY In Excel

• How To Do A Basic Data Analysis In Excel (CHART INCLUDED!)

• My QUICK And EASY Method For Building An Interactive Dashboard In Excel

• Why You Should Learn Excel’s Data Analysis Formulae (EXCEL PIVOT TABLE ALTERNATIVE!)

• How To Create BEAUTIFUL Charts In Excel

• What's An Excel 'Model'? (AND 5 EXCEL MODEL-BUILDING FORMULAE!)

• The Secret To Smooth Formula-Building In Excel (EXCEL MODELLING FOR BEGINNERS!)

• Build This BEGINNER EXCEL MODEL With Me In Around 15 Minutes!

• How To Create BEAUTIFUL Visualisations For Excel Models

• THE BASICS OF EXCEL VBA EXPLAINED (For Beginners!)

• Frustrated With Recorded Macros In Excel VBA? HERE'S HOW TO IMPROVE THEM

• 5 ESSENTIAL Excel VBA Beginner Techniques

• How Automate Manual Work In Excel With Loops In Excel VBA

• How To Generate UNLIMITED Random Data In Excel (CLICK OF A BUTTON!)

• SAVE TIME IN EXCEL With These 23 Excel Keyboard Shortcuts (WINDOWS PC)

• 5 Formatting Principles For Better Excel Spreadsheets

• 4 Worksheets To Include In ALL Your Excel Files (GENERIC EXCEL SHEET ROLES!)

• What's The Difference Between An ANALYST And A CONSULTANT? And Why Does It Matter For YOUR Career?

• 4 NON-EXCEL Tools To Help You Create Better Spreadsheets

• How Can DRAWING Help You Create Better Excel Spreadsheets?

• How Should You Manage An Excel Development Project? (4 STEPS!)

• How To Make Excel Your Career (IN FOUR STEPS!)

• Can You Become An Excel Analyst In 30 Days? (COURSE OVERVIEW)

• What's Your Excel Personality? (M,A,O,R)

• 5 Modern Excel Formulae To Take You Further

• 5 Essential Excel Formulae To Start Your Journey

• Excel Formatting For Absolute Beginners

• What You've Been Getting Wrong About Excel

• How To Use Excel Tables And Excel VBA To Automate Manual Work

• 26 Excel Productivity Tips For 2026

• EXCEL: STATE OF THE UNION (How To Save Your Excel-Related Career)

• THE EXCEL NIGHTMARE

• Excel VBA To Copy Data From One FILE To Another (BEGINNER TO PRO! PART 2/2)

• How To Format An Excel Spreadsheet (CHECKLIST INCLUDED!)

• How To Stop Data Leaks In Excel (8 MUST-KNOW EXCEL TIPS!)

• Excel VBA To Copy Data From One FILE To Another (BEGINNER TO PRO! PART 1/2)

• STOP PAYING! Use EXCEL Instead For These 7 Software Tasks

• Excel Forms Beginner Tutorial

• How To Collect Data In Excel In 2025 (STOP ANNOYING COWORKERS!)

• MIC'D UP: EXCEL DEVELOPER TAKES ON THE EXCEL WORLD CUP

• THE 5 LEVELS OF EXCEL AUTOMATION

• How To Automate Powerpoint Creation With Excel VBA (INSTANT PRESENTATIONS!)

• Excel Office Script for Beginners - Part 3 of 3: Create A Loop In Excel Office Script

• Excel Office Script for Beginners - Part 2 of 3: Manipulate Cells With Office Script

• EXCEL VBA MASTER TIP: The Best Way To Copy / Paste Data From One Sheet To Another In Excel?

• Stop Obsessing Over Excel Formulas! YOU'RE MISSING THIS ...

• Excel VBA To Copy Data From One File To Another (BEGINNER TO PRO!)

• Don't Copy / Paste Data In Excel! Use These 5 Alternatives Instead ...

• Excel VLOOKUP Formula For Beginners

• Excel Dashboards For Beginners

• 25 Powerful Excel VBA Techniques For 2025

• The Excel Mistake That KILLS Small Businesses

• Excel Office Script For Beginners (AND VBA ADDICTS!) Part 1/3

• 3 Excel Calamities (FROM THE TIMES!) And How To Avoid Them

• RIP: MY EXCEL VBA CAREER (2008-2024)

• AVOID This Excel Formatting Mistake (DO THIS INSTEAD!)

• INSANELY Simple Excel Formatting Trick That Works EVERY Time

• THE ONE FORMULA I WISH EXCEL HAD (+How To Build It Yourself!)

• The 30 Excel Formulae You Must Know In 2024 (1-HOUR MASTERCLASS!)

• Power Automate For BEGINNERS

• Learn Macros In 19 Minutes (Microsoft Excel)

• Learn Excel's BEST Automation Tool In 15 Minutes!

• Learn The Easy Way To Transfer Data With Excel VBA In Around 5 Minutes! (WITH DOWNLOAD FILES)

• How To Do What VLOOKUP Can't Do With OFFSET and MATCH

• How To Categorise Numbers In Excel Using VLOOKUP

• When You SHOULD Use INDIRECT

• How To Remove Spaces in Excel (When TRIM Doesn’t Work!)

• Complete Manual Excel Tasks In Seconds With THIS Excel Formula

• Learn This Powerful Excel Formula Combination In Just 5 Minutes!

• How To Model Winning And Losing Streaks In Excel

• BEYOND THE MACRO RECORDER

• Why Short Excel Formulae Are Better Than Long Excel Formulae (WITH PRACTICAL DEMO)

• 17 Excel Beginner Formatting Mistakes (AND HOW TO FIX THEM!)

• How To Format Your Excel Spreadsheet Quickly And Professionally With 26 Excel Keyboard Shortcuts

• Excel Conditional Formatting Tutorial (FROM BEGINNER TO PRO!)

• How Excel Knows If You're Working On Mac Or PC

• 14 MORE Excel Formatting Tips (Make Excel Beautiful AGAIN)

• Excel's Most Powerful Data Analysis Formula Explained In 5 Minutes

• How To Use Conditional (IF) Statements In Excel VBA (Real-World VBA Task S3 P6)

• Get Started With Position Control In Excel VBA (Real-World VBA Task S3 P5)

• How To Combine Two Loop Types In Excel VBA (Real-World VBA Task S3 P4)

• How To Build A Loop Within Loop In Excel VBA (Real-World VBA Task S3 P3)

• How To Build A Loop In Excel VBA (Real-World VBA Task S3 P2)

• How To Start An Excel VBA Macro (Real-World VBA Task S3 P1)

• How To Analyse Goal Distribution In Excel (BEGINNER EXCEL DATA ANALYSIS!)

• 3 Alternatives To SUBTOTAL To Analyse Football Data In Excel (PLEASE STOP!)

• Complete Guide To Excel For Football Traders

• Why I Don't Use Excel Tables

• Don’t Just Use =AVERAGE In Your Excel Data Analysis! Do This Instead

• 14 Excel Formatting Tips (Make Excel BEAUTIFUL!)

• How To Automate VLOOKUP With Excel VBA

• Can We Get Excel To Play Chess With Excel VBA? (INFINITY PROJECT)

• How To Analyse Bitcoin ($BTC) Price In Excel

• 10 Ways My Excel VBA Has Improved In 10 Years (BEGINNER TO PRO!)

• Make Excel VBA Loops EASY With The Loop Blueprints (MM LITE #5)

• Excel VBA Arrays For Beginners

• The 3 Excel Superpowers

• Even Beginners Can Learn Loops In Excel VBA ... (MM LITE #4)

• The Only 3 IF Statements You Need In Excel VBA - Excel VBA Beginner Fundamentals (6/6)

• Beginner Survival Guide To Working With Dates And Times In Excel

• Create An Excel Combo Chart In 7 Easy Steps (MM LITE #3)

• My No1 Excel VBA Technique Explained In 10 Minutes

• The BEST Way To Move Sheets Between Files In Excel (MM LITE #2)

• Master Excel's 11 Logical Formulae

• How To Create A Loop Within A Loop In Excel VBA (MM LITE #1)

• I Tried To Learn 500 Excel Formulae

• Get Started With Loops In Excel VBA

• Beginner Introduction To Variables In Excel VBA

• 10 Popular Excel Formulae: OVERRATED / UNDERRATED?

• How To Work With Cells With Excel VBA

• Excel VBA Beginner Fundamentals

• 10 Excel Formula Building Tips (Windows PC)

• 7 Useful Excel Formulae You've Never Heard Of

• What's The Best Excel Chart For Beginners?

• Excel Data Analysis For Beginners: Learn This Formula FIRST

• Why I Don't Use Pivot Tables In Excel

• The ONE Excel Beginner Formula That Does ALL This

• The 72 Things You Need To Know In Excel In 7 Minutes 2 Seconds

• Let's Fix 5 Shocking Excel Pie Charts (SAVE A FRIEND!)

• Should You Learn Excel VBA In 2021? 7 Questions To Answer

• Excel VBA To Copy Data From One Sheet To Another (BEGINNER TO PRO!)

• XLOOKUP For Beginners (And Why I'm Sceptical About New Excel Formulae ...)

• Can’t Do Data Analysis In Excel? Just Do This!

• Make Your Excel Data Chartable With This EPIC Excel Formula

• Replace Excel Filtering ... With An Excel FORMULA?

• The Best Alternative To Excel Filters?

• Don't Use Excel Filters! Use This Incredible Excel Formula Instead ...

• How To Validate Userform Inputs With Excel VBA

• 3 Ways To Insert A Reference No. Using An Excel Userform

• 3 Excel Data Analysis Techniques You Should Be Using

• Excel VBA For Beginners: 30 Real World Problems And Solutions

• How To Make Money From Excel

• Excel VBA Position Control Mastery

• 9 Reasons (NOT) To Do An MBA

• Suffering From Excel Ennui? Why It's Not (All) Your Fault

• How To Use Excel VBA Code – Real Example S2

• How To Get Better At Excel: The Excel Metaskills

• Excel Dashboards For Beginners

• 7 Essential Excel VBA Beginner Techniques

• 17 Things You Must Know About The Excel VBA Editor

• How to Change Grades to Numbers in Excel

• How To Match A Number To A Range in Excel

• How To Use Excel VBA Code – Real Example

• Excel Indirect Function Tutorial

• Excel Data Table Tutorial

• Excel VBA to Move Data Around a File – My Approach

• Your Weird Skillset is Your Best Asset

• .Cells For Beginners

• Your First Pivot Table

• 19 Excel Beginner Shortcuts for 2019

• Understand an Excel File in 3 Steps

• Most Important Skill in Excel VBA

• VLOOKUP Formula Problems / Fixes

• Excel VBA to Copy Data to Sheets

• Excel Frequency Formula: Common Problems / Fixes

• Excel VBA to Convert Minutes to Decimals

• What are Excel VBA Variables?

• Use Excel VBA to Separate Worksheets to Files

• Working with Excel VBA Message Boxes

• Excel VBA IF Conditional Statements for Beginners

• Excel Learning Tips: My Story

• Excel Database Formulae For Beginners

• Spreadsheet Skunkworks! Excel VBA Chess Challenge

• Excel Userforms for Beginners

• Use Excel VBA to Create Spin Buttons – Really Precisely!

• Use Excel VBA to Create Buttons For Super Fast Data Input!

• How to Collate Sports Fixtures Results into a League Table in Excel

• Excel Custom Navigation: Excel VBA for Beginners

• Excel Game – Do You Know the Offside Rule?!

• Rich Picturing: Six Tips for Getting Started

• Excel VBA for Beginners – Use Excel VBA to Cleanse a Dataset

• Excel Offset Function – Give It Some Love!

• Excel Visual Basic (VBA) for Post-Beginners

• Generate Random Data in Excel

• Combining VLOOKUP and MATCH

• Dynamic Dropdown Menus in Excel

• Excel for Teachers: Create A Student Progress Tracker

• Excel Visual Basic (VBA) for Beginners

• Create A League Table in an Excel Spreadsheet

• What is Excel Spreadsheet Development?

• Rank Things and Create A League Table in Excel

• Finding Things in Lists of Data in Excel

• #ExcelRevolution Manifesto

• Cool Excel Formatting: Font Size and Colour

• #ExcelRevolution Introduction

• Combining MATCH and OFFSET

• Cool Excel Formulae: COUNTIF

• Cool Excel Formatting: Dynamic Headers

• Cool Excel Formulae: IF

• Cool Excel Formatting: Cell Borders

• Cool Excel Formulae: VLOOKUP

• Cool Excel Formulae: MATCH

• Cool Excel Formulae: OFFSET

• Cool Excel Formulae: COUNTA

• Cool Excel Formulae: IFERROR