Today is the Topic
Sure! VLOOKUP and HLOOKUP are Excel functions used to search for a value in a table and return a corresponding value in a specified row (for VLOOKUP) or column (for HLOOKUP). Here’s an explanation of both with examples:
1. VLOOKUP (Vertical Lookup):
– VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.
– Syntax: `VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])`
– `lookup_value`: The value you want to search for.
– `table_array`: The table where the data is located.
– `col_index_num`: The column number in the table from which to return the value.
– `range_lookup`: Optional. TRUE for an approximate match or FALSE for an exact match. (Defaults to TRUE if omitted).
– Example: Let’s say you have a table with student names in column A and their corresponding grades in column B. You want to find the grade of a student named “John”. You could use the formula `=VLOOKUP(“John”, A1:B10, 2, FALSE)`.
2. HLOOKUP (Horizontal Lookup):
– HLOOKUP searches for a value in the top row of a table and returns a value in the same column from a specified row.
– Syntax: `HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])`
– `lookup_value`: The value you want to search for.
– `table_array`: The table where the data is located.
– `row_index_num`: The row number in the table from which to return the value.
– `range_lookup`: Optional. TRUE for an approximate match or FALSE for an exact match. (Defaults to TRUE if omitted).
– Example: Suppose you have a table where the first row contains product names and the second row contains their respective prices. You want to find the price of a product named “Apple”. You could use the formula `=HLOOKUP(“Apple”, A1:D2, 2, FALSE)`.
These functions are handy for quickly retrieving data from large tables based on specific criteria.
With some short cut key chart here.
