Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
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.
Use to search data or information in horizontal or vertical database
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"
V lookup does the look up Vertically, and H lookup does it Horizontally.
Vlookup is vertical lookup. Here you look for values in vertical columns by specifying unique lookup criteria.e.g.:
=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])
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.
for example : you have a table containing names and phone number for each one