How to Make a Lookup Table in Excel

In this video, I'll guide you through the 5 ways to create a lookup table in Excel. You'll learn to use the XLOOKUP, LOOKUP, VLOOKUP, HLOOKUP and combine the INDEX & MATCH functions. Creating a lookup table allows you to replace complex calculations with simple lookup operations. With practical examples and step-by-step instructions, you can ...

Apr 20, 2024

Excel Lookup Functions

30:58

Master Excel Lookup Functions: Step-by-Step Guide

YouTubeSkillnator

1.1K viewsJul 22, 2024

54:52

Lookup Functions in Excel - Get to Know Your Lookup Functions

YouTubeSimon Sez IT

14.9K viewsMay 31, 2022

5:51

How to use Lookup Function in Microsoft Excel | Lookup Formula in Excel

YouTubeStudySpan

42.3K views1 year ago

Top videos

1:09

How to Create lookup tables in Excel

YouTubeExcel, Word and PowerPoint

243.4K viewsNov 23, 2012

2:38

How to create lookup table in Excel

YouTubeSpreadCheaters

13.2K viewsDec 8, 2022

1:01:36

How to use Lookup Functions in Excel: VLOOKUP, INDEX and MATCH, and XLOOKUP Training Tutorial

YouTubeSimon Sez IT

42K viewsMar 19, 2024

Excel VLOOKUP Tutorial

5:32:33

🔥 Excel Full Course For Beginners | Excel Basics Training Course 2023 | Simplilearn

YouTubeSimplilearn

162.3K viewsSep 30, 2023

47:31

Learn Microsoft Excel Tutorial For Beginners in UNDER 45 MINUTES! (Microsoft Office 365 Excel)

YouTubeMyExcelOnline.com

152.6K viewsMar 12, 2021

10:30:00

Microsoft Excel Tutorial for Beginners | Excel Training | FREE Online Excel course

YouTubeProgrammingKnowledge

2.4M viewsJan 1, 2021

1:09

Find in video from 0:00Introduction to Lookup Tables

How to Create lookup tables in Excel

243.4K viewsNov 23, 2012

YouTubeExcel, Word and PowerPoint Tutorials from Ho…

2:38

Find in video from 0:00Introduction to Lookup Tables

How to create lookup table in Excel

13.2K viewsDec 8, 2022

YouTubeSpreadCheaters

1:01:36

Find in video from 07:00Using VLOOKUP in Excel

How to use Lookup Functions in Excel: VLOOKUP, INDEX and MAT…

42K viewsMar 19, 2024

YouTubeSimon Sez IT

1:01

How to use VLOOKUP in Excel

3.7M viewsNov 25, 2019

YouTubeMicrosoft 365

VLOOKUP in Excel | Step-by-Step Tutorial for Beginners

5:43

Find in video from 04:29Convert the data range into an Excel table

VLOOKUP in Excel | Step-by-Step Tutorial for Beginners

1.2M views11 months ago

YouTubeKevin Stratvert

How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)

13:34

Find in video from 0:00Introduction to XLOOKUP

How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)

3.8M viewsNov 28, 2019

YouTubeLeila Gharani

8:18

How to Use XLOOKUP in Excel – Step-by-Step Tutorial for Beginners

122.5K views7 months ago

YouTubeKevin Stratvert

5:03

Find in video from 00:11Introduction to the LOOKUP Function

How to use the LOOKUP Function in Excel

886.2K viewsAug 20, 2013

YouTubeComputergaga

5:51

How to use Lookup Function in Microsoft Excel | Lookup Formula …

42.3K views1 year ago

YouTubeStudySpan

7:26

Find in video from 00:09Lookup Function for Vertical Table

MS Excel - Lookup Function

1.2M viewsJan 15, 2018

YouTubeTutorialsPoint

32:09

Find in video from 04:51Creating a Table with VLOOKUP

VLOOKUP in Excel | Tutorial for Beginners

2.3M viewsMar 10, 2021

YouTubeKevin Stratvert

11:35

Find in video from 01:28Creating a Simple Dataset

Vlookup Function in Excel for Beginners

2M viewsFeb 24, 2020

YouTubeTeacher's Tech

2:58

Find in video from 00:22Example Table Setup

How to use the VLOOKUP function in Excel

4.9M viewsSep 28, 2018

YouTubeTechOnTheNet

6:30

Find in video from 0:00Introduction to VLOOKUP and HLOOKUP

VLOOKUP & HLOOKUP in Excel Tutorial

703.2K viewsMay 21, 2018

YouTubeKevin Stratvert

3:45

Find in video from 0:00Introduction to VLOOKUP

EXCEL VLOOKUP: How to LOOKUP DATA from Another SHEET!

744.3K viewsJan 2, 2020

YouTubeOnline Training for Everyone

4:20

Find in video from 0:00Introduction to LOOKUP Function

How to Use the LOOKUP Function in Excel - Tutorial

33.8K viewsMar 11, 2019

YouTubeY. Acosta Excel Tutorials

6:42

How to do Lookups with Multiple Criteria in Excel 365

12.5K views11 months ago

YouTubeSimon Sez IT

10:58

VLOOKUP in Excel Explained 🔍 | Lookup Smarter with Data Validati…

3.6K views2 months ago

YouTubeTutorialsPoint

0:51

Master the LOOKUP Function in Excel | Beginner to Advanced Tut…

1.6K views7 months ago

YouTubeOffice Shortcut

3:44

Find in video from 00:02Introduction to Lookup and Reference Functions

How to use LOOKUP function and Reference functions in Excel :Tuto…

140.3K viewsJul 31, 2015

YouTubeHow-To Guide

0:54

How to use the XLOOKUP function in Microsoft Excel

203.7K viewsMar 12, 2021

YouTubeMicrosoft 365

2:40

Find in video from 00:31Lookup Table Setup

TWO COLUMN Lookup in Excel with the XLOOKUP Function

23.8K viewsAug 21, 2023

YouTubeComputergaga

3:01

Find in video from 00:22Example Table Setup

How to use the HLOOKUP function in Excel

683.6K viewsOct 1, 2018

YouTubeTechOnTheNet

6:16

Find in video from 00:43Creating a Named Range

How to Do a VLOOKUP in Excel - in 6 Minutes

7.7M viewsJul 20, 2012

YouTubeVitaminCM

13:39

Find in video from 0:00Introduction to XLOOKUP

How to Use XLOOKUP in Microsoft Excel

201.8K viewsJan 4, 2020

YouTubeKevin Stratvert

7:35

how to do vlookup function in excel ( multiple sheets)/ v lookup with di…

1M viewsMar 11, 2019

YouTubeICL CLASSES

6:59

Find in video from 03:10Calculating Table Height

Make a Dynamically Updated Vlookup Table in Microsoft Excel

143.3K viewsJan 12, 2009

YouTubeTeachExcel

5:32

VLOOKUP in Excel with Copilot AI (No Formula Needed!)

43K views5 months ago

YouTubeKevin Stratvert

0:37

Master the LOOKUP Function in Excel | Easy Step-by-step Guide fo…

496 views8 months ago

YouTubeTECHTODAYHUB

See more videos

Top suggestions for How to Make a Lookup Table in Excel