Not using the formula in a cell, but the answer.
Posted by Daren on January 18, 2002 2:24 PM
I have this formula in one column of data as an array =IF(COUNTBLANK(T6:AS6)>0,INDIRECT(ADDRESS(ROW(),MIN(IF(ISBLANK(T6:AS6)*(COLUMN(T6:AS6))>0,COLUMN(T6:AS6)))-1)),"")
The formula returns a date if one cell is blank.
I need to use the date returned in a vlookup formula so that the names of people within 15 days of the returned date are displayed.
When I use =VLOOKUP(">NOW()-15",Enrolled!A4:Q101,6) on another sheet, it returns the same person over and over and a person who a date is not assigned to.
Thanks for your help.
Posted by Barrie Davidson on January 18, 2002 2:33 PM
Try changing
=VLOOKUP(">NOW()-15",Enrolled!A4:Q101,6)
to
=VLOOKUP(">NOW()-15",Enrolled!A4:Q101,6,0)
This requires an exact match for the lookup value.
Regards,
Barrie
Posted by daren on January 18, 2002 5:33 PM
--------
The vlookup is not hard for me the problem is that the vlookup keeps testing the "Enrolled!A4:Q101" where the above fomula is entered, and that throws off the answer because I do not want it to test the information in the cell which is the formula, I want it to test the data or answer that is returned from the formula.
Posted by Barrie Davidson on January 21, 2002 6:03 PM
Daren, I obviously misunderstood your requirements. After re-reading your post I am confused. Do you think you could send me a sample of your file along with a description of what the required results are.
BarrieBarrie Davidson
