Hello everybody,
Is it possible to have 2 criteria of which either one can be met to return a value?
=IFERROR(INDEX(GMF!D:D,AGGREGATE(15,6,ROW(GMF!$A$2:$A$250)/(GMF!$D$2:$D$250<31),ROWS(B$3:B3))),"")
This function return a name and a number of day until a person is due for requalification when the cell display < 31 days in a different sheet. Is it possible to add a second argument where the same data will be returned if the cell either displays < 31 days or the word "Overdue" in it. The way the worksheet is done, once the counter hits < 1 day, instead of a number of days, the cell will display "Overdue" and because of that, the above function does not return a person's name anymore since the criteria is no longer met.
If you look in the "Overview" sheet of the attached file, only 3 of the 4 names are pulled from the "GFM" and "FMF" sheets because the 4th name is no longer a digit, but a text of "Overdue". I am trying to get it to display the names and number of days < 31 along with any entries that are also Overdue as they are also due for requalification.
Thank you for your help!
Bookmarks