Excel Tutorial – How to use lookups, vlookup and hlookup

Video Tutorial


In this video, we show you how to use lookup functions in Excel.

VLOOKUP

=VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
Use VLOOKUP, one of the lookup and reference functions, when you need to find things in a table or a range by row. For example, look up an employee’s last name by her employee number, or find her phone number by looking up her last name (just like a telephone book).

HLOOKUP

=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
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.

Like this content? Share with your friends!Share on LinkedInShare on FacebookTweet about this on TwitterShare on StumbleUponShare on Tumblr