Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What make use of function Vlookup hlookup in Excel?

user-image
Question added by Ashraf Saiyad , Project & Maintenance Engineer , Hindustan Unilever Ltd
Date Posted: 2017/07/15

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.

Ammar Sharaf
by Ammar Sharaf , Technical Sales Engineer , Fair Deal General Trading

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).

Atif Tanveer
by Atif Tanveer , Decision Support Specialist , Hamilton Health Science

We use these functions to search a values in a series of values.

More Questions Like This