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