How to Use VLOOKUP and MATCH in Excel
Originally published: 27/11/2018 10:39
Publication number: ELQ-55295-1
View all versions & Certificate
certified

How to Use VLOOKUP and MATCH in Excel

We’ve seen several function combinations so far. In this lesson, we’ll present another one that can be useful.

Introduction

VLOOKUP and MATCH another useful Excel functions combination


We’ve seen several function combinations so far.
In this lesson, we’ll present another one that can be useful.

  • Step n°1 |

    VLOOKUP and MATCH

    Suppose you’d like to create a table with the number of people working in Management and Admin personnel for company D and E again.


    We can use MATCH to define the column number we need in the VLOOKUP function.


    I am sure you now know the first part of the VLOOKUP function by heart. This will be our lookup value, and we will fix its column reference. The entire table above is the lookup array.


    Cool.


    This is when MATCH comes in play. The lookup value of MATCH will be this cell.


    When I copy and paste this function, I’ll need this reference to change only when I move to the right, along the horizontal axis, and not to change when I move down. Therefore, I will anchor its row reference.

    How to Use VLOOKUP and MATCH in Excel image
add_shopping_cartContinue reading for free (70% left)

Reviews

  • Be the first to review this How-To Method

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from 365 Data Science

See all
keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for How To Use VLOOKUP And MATCH In Excel

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...