Use VLOOKUP to find a value in a table or range

Select a cell

Select the value to look up

Type, and select where to look for the value

Type , FALSE to find an exact match

Intro

Why create a Vlookup function

Entering data into the Vlookup Field

Starting the Vlookup Function

Column Index Number

TRUE or FALSE argument in VLOOKUP function

Moving the Vlookup results

Moving a cell in VLOOKUP formula

Troubleshooting Vlookup errors

Thanks for watching

Introduction

Organize data properly for VLOOKUP

VLOOKUP Exact match

Improve error message with IFERROR

VLOOKUP Closest match

VLOOKUP Across sheets

HLOOKUP

XLOOKUP Simple example

XLOOKUP Combined with other functions

XLOOKUP Returns an array

XLOOKUP Match modes

XLOOKUP Search modes

Wrap up

1. What does Vlookup function do and how does it work?

2. How to write a simple Vlookup formula?

3. The two main causes of errors with Vlookup.

4. Vlookup stops at the first match & the sorting myth.

5. How to create relationships between tables & ranges.

6. Vlookup to other sheets.

VLOOKUP example

Entering the VLOOKUP command

How VLOOKUP Works in Excel

How to Use VLOOKUP in Excel

How to Avoid #N/A in VLOOKUP

Intro

VLOOKUP flaws

VLOOKUP example

MATCH formula

INDEX formula

INDEX MATCH combined

Compare INDEX MATCH to VLOOKUP

Conclusion

Example 1: VLOOKUP to Compare Two Lists

Name the Data Range

Where to Lookup the Lookup Value

Tidying up the Results

Handling Errors in VLOOKUP

Logical Test Formula

Constructing the VLOOKUP Formula

Conditional Formatting Trick

How to Format the Formula

Conclusion

Basics of Excel VLOOKUP and HLOOKUP

How to use Excel VLOOKUP

How to use Excel HLOOKUP

Limitation of Excel VLOOKUP and HLOOKUP

Vlookup Introduction

Vlookup Example

Vlookup syntax

Introduction

Benefits of Index Match

Match Function

Index Function

Index Match

Index Match to the Left

Most Common Error

Intro

Selecting the table array

Looking up an email address

Column Index

Using VlookUp to find a phone number

Conclusion

Introduction

Objective

SUMIFS

VLOOKUP

XLOOKUP

FILTER

Conclusion

2. Why so common? Because everyone needs to look stuff up.min)

3. VLOOKUP Delivers a value to a cell: Extract Match.min)

4. VLOOKUP #N/A and IFERROR or IF.min)

5. VLOOKUP and Data Validation.min)

6. VLOOKUP with Named Range.min)

7. VLOOKUP as Formula Element.min)

8. HLOOKUP = H = Horizontal.min)

9. VLOOKUP Delivers a value to a cell: Approximate Match.min)

10. VLOOKUP with table on different sheet.min)

11. VLOOKUP with table in different workbook.min)

12. Show Full Record: Numbers above column header.min)

13. Show Full Record horizontally: COLUMNS Function.min)

14. Show Full Record vertically: ROWS Function.min)

15. Show Full Record: MATCH Functions.min)

16. Two Lookup Values: Add join column as first column in table.min)

17. Two Lookup Values: Join columns in formula and use CHOOSE function.min)

18. Partial Text Lookup: LEFT and SEARCH Functions.min)

19. Partial Text Lookup: MID Function.min)

20. Partial Text Lookup: RIGHT Function.min)

21. TRIM and VLOOKUP: Space in lookup value.min)

22. TRIM and VLOOKUP: Space in 1st column of table.min)

23. VLOOKUP with 3 lookup tables: CHOOSE Function.min)

24. VLOOKUP: Two Way Lookup with VLOOKUP and MATCH.min)

25. VLOOKUP: Variable Tax Rate, 3 VLOOKUPS in one formula.min)

26. VLOOKUP and Table feature for Dynamic ranges.min)

What is XLOOKUP?

VLOOKUP can break when you insert or delete columns

XLOOKUP defaults to an exact match

Compatibility of XLOOKUP

XLOOKUP is not backward compatible

Sharing files

Criticisms of XLOOKUP

Search mode in XLOOKUP

Should I learn VLOOKUP?

Conclusion