VLOOKUP EXPLAINED - 2 Practical Excel Lookup Examples

Sep 13, 2018 Excel Lookup Formulas
‍‍‍‍
★ Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials

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.

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

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

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.

🡻 Download the workbook here 🡻
https://www.xelplus.com/basics-vlookup-hlookup/

★ 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

★ My Online Excel Courses ► https://www.xelplus.com/courses/

✉ Subscribe & get my Excel top 10 tips and formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

GEAR I use: https://www.xelplus.com/resources/#gear

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

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!

#MsExcel #LeilaGharani