Excel Vlookup Tutorial - Everything You Need To Know
Excel Campus - Jon
@excelcampusAbout
Excel Campus is here to help you learn Excel and save you time with your everyday tasks. My name is Jon Acampora and my goal is to help you improve your Excel skills. This channel contains "how-to" tutorial style videos on a wide range of Excel topics including: formulas, pivot tables, macros, VBA, charts, dashboards, Power Query, Power Pivot, Power BI, and much more. I want to hear from you and learn about what you are struggling with in Excel. Please visit my website and subscribe to my free email newsletter. http://www.excelcampus.com/newsletter/ And don't forget to subscribe to our YouTube channel. Thank you!
Latest Posts
Video Description
Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/ In this video I explain everything you need to know to get started with VLOOKUP for Excel. Download the Excel file: https://www.excelcampus.com/wp-content/uploads/2022/06/VLOOKUP-Practice-File.xlsx This tutorial is a follow-along lesson where you will learn to write Vlookup formulas as you watch the video. It's great for beginners. However, the video is packed with additional tips and tricks for writing formulas that will help save anyone time when writing formulas. Here are the major topics covered: 00:00 1. What does Vlookup function do and how does it work? 03:26 2. How to write a simple Vlookup formula? 07:54 3. The two main causes of errors with Vlookup. 12:53 4. Vlookup stops at the first match & the sorting myth. 15:07 5. How to create relationships between tables & ranges. 15:55 6. Vlookup to other sheets. One thing I forgot to mention in the video is the F4 equivalent keyboard shortcut on the Mac version of Excel is Cmd+T. This is for toggling the absolute and relative references when writing the formula. At the end of the video I mention a bonus challenge (https://excelcampus.com/vlookup-challenge) that will help you practice and learn additional techniques with Vlookup. This includes: - The IFERROR function for handling errors. - Dynamic Vlookup formulas for adding and deleting columns. - Adding drop-down lists to create interactive spreadsheets. - Conditional formatting to highlight rows based on a matching value. - Vlookup with Excel Tables and Structured Reference Formulas. Please click the link below to download the challenge file and get access to the solution videos. It's free! 👉https://excelcampus.com/vlookup-challenge Additional Resources: Beginner's Guide to Excel Tables: https://youtu.be/fJnJTff4Na8 Video Series on Pivot Tables & Dashboards: https://youtu.be/9NUjHBNWe9M COUNTIF instead of VLOOKUP: https://youtu.be/ua6qo5gaZ9M For more tips please subscribe to our free weekly email newsletter: https://excelcampus.com/free #MsExcel #ExcelCampus
You May Also Like
Transform Your Space Today
AI-recommended products based on this video
RoboSeal Rechargeable Mason Jar Vacuum Sealer for Mason Jars Wide and Regular, One Touch Vacuum Sealer for Jars, 10 Lids Included, Digital Battery Indicator, As Seen on TV
2 Pack Outdoor Solar Firework Lights, 240 LED Solar Powered Hanging Lights Outdoor Waterproof Hanging Fairy Garden Lights Landscape Lights(Warm White)
![Command Medium Picture Hanging Strips [Removable]: 12 Pairs (White)](https://m.media-amazon.com/images/I/61IChX1hbML._AC_UL960_FMwebp_QL65_.jpg)
Command Medium Picture Hanging Strips [Removable]: 12 Pairs (White)
FoldTier 2 Sets Herb Garden Planter Indoor Kit with Trey 10 Pcs Metal Windowsill Plant Pots with Drainage Holes Indoor Herb Planter with Marker and Labels for Home Indoor Outdoor Plants (White)
Barnyard Designs Indoor Herb Garden Planter Set with Tray, Metal Windowsill Plant Pots with Drainage for Outdoor or Indoor Plants, Set/3 (White)
Hanging Planter Hanging Plant Holder, 6 Inch 4 Indoor Plant Pots, Wall/Window Plant Hanger Indoor Herb Garden
