index match subsequent values between 2 dates

[john316swan]

Trying to figure out an array formula that would pull all data between 2 dates. Here is what I started with:

{=INDEX(Loan_ID,MATCH(1,((Transfer_Dates>=Begin_Date)*(Transfer_Dates<=End_Date)),0))}

But that only returned the top value. Then I tried:

{=INDEX(Loan_ID,SMALL(IF(AND(Transfer_Dates>=Begin_Date,Transfer_Dates<=End_Date),ROW(Transfer_Dates)),ROWS(A$3:A3)))}

But that STILL only returned the top value (with subsequent values giving the #NUM! error) What am I doing wrong? Thanks for your help!!!

 

[Marcelo Branco]

Try

=IFERROR(INDEX(Loan_ID,SMALL(IF(Transfer_Dates>=Begin_Date,IF(Transfer_Dates<=End_Date,ROW(Transfer_Dates)-MIN(ROW(Transfer_Dates))+1)),ROWS(A$3:A3))),"")
Ctrl+Shift+Enter

M.