VLOOKUP EXPLAINED - 2 Practical Excel Lookup Examples

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.

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/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

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

Видео VLOOKUP EXPLAINED - 2 Practical Excel Lookup Examples канала Leila Gharani