ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

What make use of function Vlookup hlookup in Excel?

user-image
تم إضافة السؤال من قبل Ashraf Saiyad , Project & Maintenance Engineer , Hindustan Unilever Ltd
تاريخ النشر: 2017/07/15
OMAR AL-TAMIMI
من قبل OMAR AL-TAMIMI

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
من قبل 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
من قبل Atif Tanveer , Decision Support Specialist , Hamilton Health Science

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

المزيد من الأسئلة المماثلة