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