HLOOKUP() explanation

  • Thread starter Thread starter Finance Guru
  • Start date Start date
F

Finance Guru

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
 
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
 
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

| 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
 
Many thanks Mke
I think I have got it now.




Mike H said:
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
Click to expand...
 
Back
Top