HLookup Stands for Horizontal Lookup. Same as Vlookup, it looks for a value in a table but Row wise, not column wise.
Syntax of HLOOKUP
Let’s understand it by an example:
I have this data:
And I have this query
I want to retrieve data from table in I2 by just changing heading in I1 and row number in H2.
To do this, I write this HLOOKUP formula in cell I2
Now whenever you change heading, the HLOOKUP formula will show data of that heading.
The above HLOOKUP function will look for exact match in the first row of table and will return the value from given row number.
If you want an approximate match use 1 instead of 0 at range_lookup.
HLOOKUP is very useful if you are searching for data row-wise. It can be combined with INDEX function to get data using headings row titles.
HLOOKUP function is available in Excel 2016, 2013, 2010 and 2007 and maybe in older versions too (I never used them).
I hope it was resourceful. If this article on HLOOKUP in Excel was not the solution for your problem, feel free to share your problem in the comments section below. I will be happy to help you.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.