ExcelBanter - understading function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - understading function (https://www.excelbanter.com/excel-discussion-misc-queries/203264-understading-function.html)

SteW

understading function

Hi all

In the Following Formula =HLOOKUP(Itininary!$L$4,'Date
Details'!$C$3:$IV4,2,0)
my understanding is if the date that is is in 'itininary'!$l$4 is to be
searched for in the table array of 'Date Details'!$C$3:$IV4, which is in row
3. What I am not getting is that I what it to do is return the value that is
in row 4, WHICH IT DOES, but what is the significance 0f the ,2, in this
formula.

IF I WANTED IT TO RETURN THE VALUE IN ROW 70 I HAVE TO MAKE THE TABLE ARRAY
AND ROW INDEX 'Date Details'!$C$3:$IV70,68,0 and it does. again what is the
significance of ,68,

every day in every way i learn

stew

Lars-Åke Aspelin[_2_]

understading function

On Sat, 20 Sep 2008 01:29:01 -0700, stew
wrote:

Hi all

In the Following Formula =HLOOKUP(Itininary!$L$4,'Date
Details'!$C$3:$IV4,2,0)
my understanding is if the date that is is in 'itininary'!$l$4 is to be
searched for in the table array of 'Date Details'!$C$3:$IV4, which is in row
3. What I am not getting is that I what it to do is return the value that is
in row 4, WHICH IT DOES, but what is the significance 0f the ,2, in this
formula.

IF I WANTED IT TO RETURN THE VALUE IN ROW 70 I HAVE TO MAKE THE TABLE ARRAY
AND ROW INDEX 'Date Details'!$C$3:$IV70,68,0 and it does. again what is the
significance of ,68,

every day in every way i learn

stew

The table C3:IV4 is not just in row 3.
It is in rows 3 and 4.
And row 4 is the second (2) row of that table.

The table C3:IV7 is in row 3 to 70.
And row 70 is the 68'th row in the table.

Lars-Åke

David Biddulph[_2_]

understading function

One way to help your philosophy of "every day in every way i learn" is to
look up the function concerned in Excel help.
It'll tell you the syntax, give examples, and usually give "See also" links
to related functions.
--
David Biddulph

"stew" wrote in message
...
Hi all

In the Following Formula =HLOOKUP(Itininary!$L$4,'Date
Details'!$C$3:$IV4,2,0)
my understanding is if the date that is is in 'itininary'!$l$4 is to be
searched for in the table array of 'Date Details'!$C$3:$IV4, which is in
row
3. What I am not getting is that I what it to do is return the value that
is
in row 4, WHICH IT DOES, but what is the significance 0f the ,2, in this
formula.

IF I WANTED IT TO RETURN THE VALUE IN ROW 70 I HAVE TO MAKE THE TABLE
ARRAY
AND ROW INDEX 'Date Details'!$C$3:$IV70,68,0 and it does. again what is
the
significance of ,68,

every day in every way i learn

stew

SteW

understading function

"Lars-Ã…ke Aspelin" wrote:

On Sat, 20 Sep 2008 01:29:01 -0700, stew
wrote:

Hi all

In the Following Formula =HLOOKUP(Itininary!$L$4,'Date
Details'!$C$3:$IV4,2,0)
my understanding is if the date that is is in 'itininary'!$l$4 is to be
searched for in the table array of 'Date Details'!$C$3:$IV4, which is in row
3. What I am not getting is that I what it to do is return the value that is
in row 4, WHICH IT DOES, but what is the significance 0f the ,2, in this
formula.

IF I WANTED IT TO RETURN THE VALUE IN ROW 70 I HAVE TO MAKE THE TABLE ARRAY
AND ROW INDEX 'Date Details'!$C$3:$IV70,68,0 and it does. again what is the
significance of ,68,

every day in every way i learn

stew

The table C3:IV4 is not just in row 3.
It is in rows 3 and 4.
And row 4 is the second (2) row of that table.

The table C3:IV7 is in row 3 to 70.
And row 70 is the 68'th row in the table.

Lars-Ã…ke

So if C3:IV7 COVERS ROWS 3 TO 70
WHY DOES C3:IV4 ONLY COVER ROWS 3 AND 4, OR AM I MISUNDERSTANDING
i GET THE ,2, AND ,68, WHICH WAS MY INITIAL QUESTION

THANKS
STEW

SteW

understading function

Dear David

I do that but I do not find it human enough in its examples. Much better
explanations here

Best

Stew

"David Biddulph" wrote:

One way to help your philosophy of "every day in every way i learn" is to
look up the function concerned in Excel help.
It'll tell you the syntax, give examples, and usually give "See also" links
to related functions.
--
David Biddulph

"stew" wrote in message
...
Hi all

In the Following Formula =HLOOKUP(Itininary!$L$4,'Date
Details'!$C$3:$IV4,2,0)
my understanding is if the date that is is in 'itininary'!$l$4 is to be
searched for in the table array of 'Date Details'!$C$3:$IV4, which is in
row
3. What I am not getting is that I what it to do is return the value that
is
in row 4, WHICH IT DOES, but what is the significance 0f the ,2, in this
formula.

IF I WANTED IT TO RETURN THE VALUE IN ROW 70 I HAVE TO MAKE THE TABLE
ARRAY
AND ROW INDEX 'Date Details'!$C$3:$IV70,68,0 and it does. again what is
the
significance of ,68,

every day in every way i learn

stew

Lars-Åke Aspelin[_2_]

understading function

On Sat, 20 Sep 2008 02:09:01 -0700, stew
wrote:

"Lars-Åke Aspelin" wrote:

On Sat, 20 Sep 2008 01:29:01 -0700, stew
wrote:

Hi all

In the Following Formula =HLOOKUP(Itininary!$L$4,'Date
Details'!$C$3:$IV4,2,0)
my understanding is if the date that is is in 'itininary'!$l$4 is to be
searched for in the table array of 'Date Details'!$C$3:$IV4, which is in row
3. What I am not getting is that I what it to do is return the value that is
in row 4, WHICH IT DOES, but what is the significance 0f the ,2, in this
formula.

IF I WANTED IT TO RETURN THE VALUE IN ROW 70 I HAVE TO MAKE THE TABLE ARRAY
AND ROW INDEX 'Date Details'!$C$3:$IV70,68,0 and it does. again what is the
significance of ,68,

every day in every way i learn

stew

The table C3:IV4 is not just in row 3.
It is in rows 3 and 4.
And row 4 is the second (2) row of that table.

The table C3:IV7 is in row 3 to 70.
And row 70 is the 68'th row in the table.

Lars-Åke

So if C3:IV7 COVERS ROWS 3 TO 70
WHY DOES C3:IV4 ONLY COVER ROWS 3 AND 4, OR AM I MISUNDERSTANDING
i GET THE ,2, AND ,68, WHICH WAS MY INITIAL QUESTION

THANKS
STEW

Sorry, a mistype from me. C3:IV70 (not C3:IV7) covers row 3 to 70

Lars-Åke

SteW

understading function

thank you Lars

Got It

Stew

"Lars-Ã…ke Aspelin" wrote:

On Sat, 20 Sep 2008 02:09:01 -0700, stew
wrote:

"Lars-Ã…ke Aspelin" wrote:

On Sat, 20 Sep 2008 01:29:01 -0700, stew
wrote:

Hi all

In the Following Formula =HLOOKUP(Itininary!$L$4,'Date
Details'!$C$3:$IV4,2,0)
my understanding is if the date that is is in 'itininary'!$l$4 is to be
searched for in the table array of 'Date Details'!$C$3:$IV4, which is in row
3. What I am not getting is that I what it to do is return the value that is
in row 4, WHICH IT DOES, but what is the significance 0f the ,2, in this
formula.

IF I WANTED IT TO RETURN THE VALUE IN ROW 70 I HAVE TO MAKE THE TABLE ARRAY
AND ROW INDEX 'Date Details'!$C$3:$IV70,68,0 and it does. again what is the
significance of ,68,

every day in every way i learn

stew

The table C3:IV4 is not just in row 3.
It is in rows 3 and 4.
And row 4 is the second (2) row of that table.

The table C3:IV7 is in row 3 to 70.
And row 70 is the 68'th row in the table.

Lars-Ã…ke

So if C3:IV7 COVERS ROWS 3 TO 70
WHY DOES C3:IV4 ONLY COVER ROWS 3 AND 4, OR AM I MISUNDERSTANDING
i GET THE ,2, AND ,68, WHICH WAS MY INITIAL QUESTION

THANKS
STEW

Sorry, a mistype from me. C3:IV70 (not C3:IV7) covers row 3 to 70

Lars-Ã…ke

All times are GMT +1. The time now is 07:03 PM.