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