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
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