Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses

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.

⬇️ Download the workbook here https://pages.xelplus.com/vlookup-explained-file

00:00 How VLOOKUP Works in Excel
02:30 How to Use VLOOKUP in Excel
10:00 How to Avoid #N/A in VLOOKUP

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.

Links to related videos:
For reverse or 2-way lookup problems use INDEX & MATCH: https://youtu.be/F264FpBDX28
Relative & Absolute referencing: https://youtu.be/FRu48zy-Djk

️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

RESOURCES I recommend: https://www.xelplus.com/resources/

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel