Hi,

The 2 tells the formula which row from the top to return the value from so
as your table has only 1 row anything other than 1 will give a Ref error if a
match is found
=HLOOKUP(A1,B3:G4,2,FALSE)
The above formula has 2 rows so 1 or 2 is valid,

The last argument is logical a zero or TRUE returns an approximate match. A
1 or false returns an exact match only.

Mike
"Finance Guru" wrote:

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