That formula can't work. It tries to extract data from the second row of a one-row range (that is the 2 in the formula)
I find this is all well explained in Excel Help.
Here's a tutorial about VLOOKUP(). Apart from the orientation of the lookup table (vertical instead of horizontal) it is
essentially the same.
http://www.contextures.com/xlFunctions02.html
Post again in this thread if you have specific problems.
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Finance Guru" wrote in message ...
| Hello All,
|
| Could someone explain what the last 2 and the 0 characters in the function
| actually mean ( or achieve ) in the following statement
|
| =HLOOKUP(c3,d4:h4,2,0)
|
| eg. if I replace the 2 with a 1 or a 3 or 4 - all I get is error messages.
|
| I would be extremely grateful of a down to earth explanation. Then I will
| probably be able to achieve more good work knowing the answer.
|
| Kind regards