In this video, we show you how to use lookup functions in Excel.
=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(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.