Now now now! After the vertical finding of values let’s try the horizontal one. Hlookup for Horizontal Look up meaning by column. This function is same logic with Vlookup function except for lining up of finding values.
Vertical Finding – North to South
Horizontal Finding – West to East
![]() |
NEWS |
The Formula of HLOOKUP
Like VLookup, Hlookup starts from most left and upper corner of the table array (or area)
The computer will start finding your value on the upper-left corner of your desired area or table array (range D5:K6). Starts with the “Name” next is “Peter”, “Paul”, “John”, and so on then after the computer found your value (“Christian”), the searching ceases. It will match up to your index number from the same column which is “2”, generating a result of ID No. 000-0005.
Common Errors
- Always look the “lookup_value” from the 1st row of the table array
- Make sure you write the correct col_index_num (start counting from the 1st row of the table array)
Make sure you write the correct col_index_num (start counting from the 1st row of the table array or table area):
Which is true, because the table array starts from cell D6 where the computer is always start indexing from the first cell of a table array but on the other hand (index no.) is false. Obviously, the computer thinks that your “result_value” is on row 12 so the result found is “#REF!”
When there are duplicate Values in your 1st row in a table array, the first value that matches the “lookup_value” is always the basis for the outcome value of your row_index_num:
If you have questions, reactions and or suggestions. Please leave a comment 🙂