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

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