HLOOKUP() explanation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Finance Guru - 08 Feb 2008 16:59 GMT

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

Reply to this Message

Mike H - 08 Feb 2008 17:14 GMT

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

> Hello All,
>
[quoted text clipped - 9 lines]
>
> Kind regards

Reply to this Message

Finance Guru - 08 Feb 2008 17:20 GMT

Many thanks Mke
I think I have got it now.

> Hi,
>
[quoted text clipped - 22 lines]
> >
> > Kind regards

Reply to this Message

Niek Otten - 08 Feb 2008 17:17 GMT

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.

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello All,
|
[quoted text clipped - 9 lines]
|
| Kind regards

Reply to this Message