Excel - Copy a VLOOKUP formula Tutorial

In this video, you will learn how to copy a VLOOKUP formula in Microsoft 365. The video demonstrates the process of using absolute cell references by adding dollar signs to your arguments.
By doing this, you can copy the formula down a column and ensure that the references remain fixed.
The video also provides tips on using the F4 key to add dollar signs correctly and highlights common mistakes to avoid when using VLOOKUP, such as arranging data in columns and using the correct range lookup argument.
This tutorial will help you efficiently copy VLOOKUP formulas and avoid errors in your spreadsheets.

3:27
1424 views

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

Excel - The VLOOKUP function

In this video, you will learn about the VLOOKUP function in Microsoft 365. The video demonstrates how to use the VLOOKUP function to retrieve data from another table based on a reference field.
It covers the steps to select the lookup value, specify the table array, determine the column index number, and choose the match type.
This knowledge will help you effectively use the VLOOKUP function in Microsoft 365 to retrieve specific data.

595 views

Excel - VLOOKUP: How and when to use it

In this video, you will learn about VLOOKUP and how and when to use it.
The video covers the VLOOKUP function, which is similar to a phone book, where you start with a piece of data and use it to find other related information.
The video demonstrates how to use VLOOKUP to find prices based on part numbers in a large spreadsheet.
By entering the part number in a specific cell, you can retrieve the corresponding price.
This will help you efficiently find information in a large dataset and save time.

2:38
1402 views

Excel - Cell references

In this video, you will learn about cell references in Microsoft 365. The video covers how to use cell references in Excel to link and manipulate data across different cells and worksheets.
This will help you improve your data analysis and organization skills in Microsoft 365.

1:34
1324 views

Excel - Look up values on a different worksheet

In this video, you will learn how to look up values on a different worksheet using Microsoft 365. The video demonstrates how to use the VLOOKUP function to aggregate data from multiple worksheets into one place.
By entering the appropriate arguments, such as the column reference and the range of cells to search, you can find matching values and retrieve the desired information.
This tutorial will help you efficiently gather and analyze data from different worksheets, improving your data management skills.

2:39
1490 views

Excel - The HLOOKUP function

In this video, you will learn about the HLOOKUP function in Microsoft Excel.
The video covers the basic features of the HLOOKUP function and demonstrates how to use it to retrieve data based on a common element.
By specifying the search value, lookup array, returned array, and match mode, you can easily set up the HLOOKUP function.
This will help you efficiently retrieve data and complete your tasks in Excel.

497 views

RELATED COURSES This tutorial is part of the following courses

Video Training Microsoft Excel - Intermediate level

Increase your scope of action with our intermediate tutorials dedicated to formulas, advanced visual enhancement and data analysis with pivot tables, and take advantage of all that Excel has to offer!

Your trainer for this course
Cours E-learning

220 vues

ALL COURSES