Register now or log in to join your professional community.
We use the Vlookup and Hlookup functions when we need to find a value in a table ( a series of values ). Vlookup is used when there is a vertical table. Hlookup is used when there is a Horizontal table.
VLOOKUP Searches for a value in an array or table's first column and returns any value of that same row that contains the searched term.
EXAMPLE: =vlookup("Ashraf",A1:C3,2,FALSE)
This will look in3 cells (A1, A2 and A3) for "Ashraf", and return a value in column B (because3rd argument is2) with the matching row of "Ashraf" cell. If "Ashraf" was in A2, that function will return the value of B2. The4th argument (False) determines exact matching (TRUE for similar matching).
HLOOKUP Searches for a value in an array or table's first row and returns any value of that same column that contains the searched term.
EXAMPLE: =hlookup("Ashraf",A1:C3,3,FALSE)
This will look in3 cells (A1, B1 and C1) for "Ashraf", and return a value in row3 (because3rd argument is3) with the matching column of "Ashraf" cell. If "Ashraf" was in B1, that function will return the value of B3. The4th argument (False) determines exact matching (TRUE for similar matching).
We use these functions to search a values in a series of values.