VLOOKUP and HLOOKUP are Excel functions that allow users to look up values and return matching data from tables. VLOOKUP searches across columns to find a match and return a corresponding value, while HLOOKUP searches across rows. Both functions take the lookup value, table array, and index number as arguments and can optionally specify an exact or approximate match type.
VLOOKUP and HLOOKUP are Excel functions that allow users to look up values and return matching data from tables. VLOOKUP searches across columns to find a match and return a corresponding value, while HLOOKUP searches across rows. Both functions take the lookup value, table array, and index number as arguments and can optionally specify an exact or approximate match type.
VLOOKUP and HLOOKUP are Excel functions that allow users to look up values and return matching data from tables. VLOOKUP searches across columns to find a match and return a corresponding value, while HLOOKUP searches across rows. Both functions take the lookup value, table array, and index number as arguments and can optionally specify an exact or approximate match type.
VLOOKUP and HLOOKUP are Excel functions that allow users to look up values and return matching data from tables. VLOOKUP searches across columns to find a match and return a corresponding value, while HLOOKUP searches across rows. Both functions take the lookup value, table array, and index number as arguments and can optionally specify an exact or approximate match type.
Download as PPTX, PDF, TXT or read online from Scribd
Download as pptx, pdf, or txt
You are on page 1/ 4
Presentation on
VLOOKUP & HLOOKUP
Presenting, Md Khairul Hasan Khan ID:2230404 What is VLOOKUP & HLOOKUP? What is VLOOKUP? • What is HLOOKUP? HLOOKUP stands for Horizontal Lookup and can The VLOOKUP function is a premade be used to retrieve information from a table by function in Excel, which allows searching a row for the matching data and searches across column outputting from the corresponding column. While VLOOKUP searches for the value in a column, HLOOKUP searches for the value in a It is typed =VLOOKUP row.
It is typed =HLOOKUP
It has the following parts: It has the following parts: =VLOOKUP(lookup_value, table_array, c =HLOOKUP(lookup_value, table_array, ol_index_num, [range_lookup]) row_index_num, [range_lookup]) VLOOKUP HLOOKUP
