Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What is the use of VLOOKUP & HLOOKUP function in Excel?

user-image
Question ajoutée par md saood manzar , Lab Researcher Air Pollution Lab , university of dammam
Date de publication: 2017/05/11
Ram P
par Ram P , Functional Consultant , HCL Technologies LTD

VLOOKUP allows you to search a table that is set up vertically. That is, all of the data is set up in columns and each column is responsible for one kind of data. In the Student Record example, there would be a separate column of data for Student Names, one for Student ID numbers, etc. HLOOKUP is the exact same function, but looks up data that has been formatted by rows instead of columns.

MA THERESA CYRHYLL MACEDA
par MA THERESA CYRHYLL MACEDA , PROJECT PLANNER / PROJECT MANAGER , UNITED FACILITIES MANAGEMENT SERVICES

Use to search data or information in horizontal or vertical database

Mohammed Yasser
par Mohammed Yasser , team leader procurement and material planning , Juhayna for Food industries

Vlook up is used to look up for a certain value inside a sheet with reference to original Value "it looks up through columns and H Lookup throu Rows"

Mahmood Alsaeed
par Mahmood Alsaeed , Human Resource Coordinator , Al-Khobar

V lookup does the look up Vertically, and H lookup does it Horizontally.

 

Arsalan Zafar
par Arsalan Zafar , HR/Admin Incharge , Madiha Enterprises

Vlookup is vertical lookup. Here you look for values in vertical columns by specifying unique lookup criteria.e.g.:

vlookup2.jpg

=vlookup(C2,"Table name,3,false)

Same way Hlookup will look for value horizontally. The Microsoft Excel HLOOKUP function performs a horizontal lookup by searching for a value in the top row of the table and returning the value in the same column based on the index_number.

The HLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the HLOOKUP function can be entered as part of a formula in a cell of a worksheet.

=hlookup(value,table,index number,[approximate match])

Ashraf Ahmed
par Ashraf Ahmed , administrative assistant , Munshat real estate projects co

VLOOKUP and HLOOKUP are two of the most popular formulas in Excel and using them together is one of the first formula combinations that people learn.  While using INDEX MATCH for vertical lookups and INDEX MATCH MATCH for matrix style lookups are superior approaches, it’s still a good idea to learn this formula combination and add it to your toolkit of lookup approaches.  You may find yourself in a situation where you encounter this formula combination after inheriting someone else’s file, or you may just be working with someone who does not understand INDEX MATCH.  Both of these contexts make it worthwhile to learn VLOOKUP HLOOKUP.

Mehrez Mannai
par Mehrez Mannai , Audit Technique , Poulina Group Holding

VLOOKUP simply looks for something in a range of cells and returns something that’s in the same row as the value you want to seek

for example : you have a table containing names and phone number for each one

 

VLOOKUP will help you if you tape the name to show you the phone number

More Questions Like This