How to Use VLOOKUP in Excel

3 CQ

In this lesson, learn about using VLOOKUP to combine data sets, the parameters the function takes, and how to execute VLOOKUP with an evaluation example.

  • Recommended Recommended
  • History & In Progress History
  • Browse Library
  • Most Popular Library

Get Personalized Recommendations

Let us help you figure out what to learn! By taking a short interview you’ll be able to specify your learning interests and goals, so we can recommend the perfect courses and lessons to try next.

Start Interview

    You don't have any lessons in your history.
    Just find something that looks interesting and start learning!

    5 Comments
    500 characters max

    cynthia j
    Love this lesson, thanks for the breakdown about the 4 pieces of info needed!
    appreciate appreciated
     –  reply
     –  delete

    Curious .
    Cynthia, thank you!
    appreciate appreciated
     –  reply
     –  delete
    500 characters max

    Kit K
    Awesome job!
    appreciate appreciated
     –  reply
     –  delete
    500 characters max

    Kit K
    Thank you! Makes so much more sense than when my trainer at work was trying to teach me. I ended up just nodding & saying "ok" to her through the whole thing, but was really screaming in my head "WTF is she saying?!" Lol Great job! =)
    appreciate appreciated
     –  reply
     –  delete

    Curious .
    Kit, thanks! vlookup is one of the trickier functions in Excel. I'm glad to hear it makes sense now.
    appreciate appreciated
     –  reply
     –  delete
    500 characters max