98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Microsoft Excel - hlookup
Microsoft Excel - hlookup
Resolved · Low Priority · Version 2003
RE: Microsoft Excel - hlookup
Hello Chris
Thank you for your question and welcome to the forum.
The HLOOKUP function has 4 parts: the lookup value, the table array, column index number and range (true or false).
The table array (second part of the function) refers to the whole table, where the heading for each row runs down one column.
Each row in the table array is allocated a number, with number 1 referring to the first/top row; and each following row being numbered consecutively.
The lookup value is something that you want Excel to find row number 1.
The column index number refers to which row (e.g. 2, 3...) that you want Excel to extract information from, so Excel will look across row 1 for the lookup value you specify, then it will go to the row you specify (by it's column index number) and extract the piece of data that corresponds with your lookup value (i.e. is in the same column as the lookup value).
The range (true or false) specifies if you want Excel to provide an exact match to your lookup value (you must specify false if this is the case) otherwise Excel will provide an approximate match to your lookup value (i.e. 'near enough is good enough').
I hope this helps.
Amanda
RE: Microsoft Excel - hlookup
Dear Chris
Thank you for attending the Excel Advanced course. I hope you enjoyed the course and benefited from it.
HLookup is basically a function that can help you to retrieve data from a table that may have lots of information. Please note that you can only use Hlookup if the column headings in the table are arranged Horizontally. If the main headings are arranged in columns then you have you use the VLookup. Normally people have the data arranged in this format.
In the HLOOKUP Dialog box there are Four boxes. Let
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Outlining - ungrouping rows or columnsHighlight want you want to ungroup and press ALT + SHIFT + right cursor arrow |