Utilizing a similiar array formula to this one:

=IF(ISBLANK(A2),"",IF(D2<>"","INFO",IF(NOT(ISNA(VLOOKUP(A2,'Stip &
Ord'!IV_D,1,0))),"IAPT",IF(NOT(ISNA(VLOOKUP(A2,Repay!IV_D,1,0))),"RCPO","NOIP"))))

Is there any way to set cell D2 as an option? For instance, currently by
entering the date in field D2, the result will be "INFO". What I would like
to do is continue using the initial formula, but if the result is "IAPT" or
"RCPO", then I would like to pull their effective dates from their respective
worksheets and place in D2. Is this a possibility?