HLookup vsVLookup: Difference between HLookup and VLookup
What is Hlookup?
The full form of HLookup is Horizontal Lookup. It is a popular function that finds elements horizontally across a group of rows in a table.
What is Vlookup?
The full form of VLookup is Vertical Lookup. It is a function used to finds elements vertically in a row of a table. It scrutinises for a value vertically and remits an exact value, depending on the column number provided in Excel.
Difference between HLookup and VLookup
|
S.No. |
HLOOKUP |
VLOOKUP |
|
1 |
The full form of HLookup is Horizontal Lookup. |
The full form of VLookup is Vertical Lookup. |
|
2 |
It search the value horizontally. |
It searches the value vertically. |
|
3 |
We barely use this function when compared to the use of the VLookup function. |
We mostly prefer the VLookup function as compared to the HLookup function. |
|
4 |
We use this function, when the data is arranged in rows. |
We use this function, when the data is arranged in columns. |
|
5 |
This function remits the probed value in the same column. |
This function remits the probed value in the exact row but in the next column. |
Keep learning and stay tuned to get the latest updates on GATE along with GATE Preparation Books & GATE Answer Key and more.
Comments