Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Master Excel's most powerful lookup functions through this comprehensive 49-minute course covering VLOOKUP, HLOOKUP, and XLOOKUP techniques. Learn to perform exact and approximate matches with VLOOKUP, including advanced applications like using named ranges, cross-sheet lookups, and data validation dropdowns. Discover how to enhance your formulas with nested IFERROR functions to handle lookup errors gracefully. Explore HLOOKUP for horizontal data searches and advance to XLOOKUP, Excel's newest and most flexible lookup function that replaces traditional methods with enhanced capabilities. Practice with real-world examples and downloadable course files while building skills in data analysis, streamlining workflows, and making data-driven decisions more efficiently.
