Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |