Questions on ARRAYS

[Sammy1994]

Hello,

Hoping to find someone who knows a solution to this

I'm building a search bar that list the dates depending on how many times it has been returned.

There are 2 columns Received (B14:B17) and Shipped (C14:C17)

My received column has this, it is functional. However, I've tried modifying this formula to retrieve the shipped out dates in Column L rather than F and it doesn't function right coming up with #REF errors. I'm not sure how or What I could do what to change it a tad to get the results I want.

=IF(ISERROR(INDEX('Air Copy'!$E1:$F10000,SMALL(IF('Air Copy'!$E:$E=$A$12,ROW('Air Copy'!$E:$E)),ROW('Air Copy'!1:1)),2)),"",INDEX('Air Copy'!$E1:$F10000,SMALL(IF('Air Copy'!$E:$E=$A$12,ROW('Air Copy'!$E:$E)),ROW('Air Copy'!1:1)),2))

Anything Helps.

Thank you,

Sam

 

[dfsobral]

in the if statement inside SMALL your are returning a line 1 if false in column E
i would check that, different sizes

there other things i don't like in this formula but not even going to touch it without the source of the data