YouTube: VLOOKUP EXPLAINED - 2 Practical Excel Lookup Examples [Leila Gharani]

YouTube thumbnail image

WATCH ON YOUTUBE NOW:
VLOOKUP EXPLAINED - 2 Practical Excel Lookup Examples
Leila Gharani

Quickly learn the ins and outs of Excel's VLOOKUP formula. I show 2 practical examples of the VLOOKUP formula. I also explain why your VLOOKUP formula might not be working correctly.

Summary: The Excel VLOOKUP formula looks up a value in an Excel table and returns a value from an adjacent column. "V" stands for vertical lookup. This is one of most common lookup functions in Excel.

If your data table is not sorted, it's important to look for an exact match - this means you can't omit the last argument of vlookup. You need to set that argument to "false" or to 0.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×