VLOOKUP & HLOOKUP in Excel Tutorial

Easy video tutorial showing you step by step how to Vlookup and Hlookup in Microsoft Excel. As full disclosure, I work at Microsoft.

The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. The VLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function.

The HLOOKUP function searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find.

The H in HLOOKUP stands for “Horizontal.”

See all Excel tutorial videos here: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
– Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com

Related Posts

How to use VLOOKUP in Microsoft Excel

How to use VLOOKUP in Microsoft Excel

Facebook0Twitter0Google PLuse00Shares 7 Views Use VLOOKUP when you need to find things in a table or a range by row in Microsoft Excel. For example, look up…

VLOOKUP in Excel | Tutorial for Beginners

VLOOKUP in Excel | Tutorial for Beginners

Facebook0Twitter0Google PLuse00Shares 14 Views 🔥 Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com In this step-by-step tutorial, learn how to use VLOOKUP, HLOOKUP, AND XLOOKUP in Microsoft Excel….

Language »
close
Thanks !

Thanks for sharing this, you are awesome !