Index Match Row Formula Error?

[reneresendez]

I have a sheet with data sometimes in excess of 1000 rows, I have a sheet labeled "Results"


This is how the data sheets looks (I've only include a small amount of data to explain my request)


A B C D

SIZE ID UPC NAME

R4 28FT 123 4569 HOT DOG

R5 28FT 321 6549 BUN

R6 28FT 987 5679 MUSTARD

R7 28FT 888 9898 ONION

R8 24FT 123 4569 HOT DOG

R9 24FT 321 6549 BUN

R10 24FT 444 7767 WHEAT BUN


In F2 I have dropdown List with 24FT & 28FT


F4 =INDEX($A$4:$D$10,MATCH($F$2,$A$4:$A$10,0)+ROW(A1)-1,2)

G4 =INDEX($A$4:$D$10,MATCH($F$2,$A$4:$A$10,0)+ROW(A1)-1,3)

H4 =INDEX($A$4:$D$10,MATCH($F$2,$A$4:$A$10,0)+ROW(A1)-1,4)


My formula running from F4 to H10


When I set F2 to 28FT, I only want the Rows that have 28FT to display, the same for 24FT


Currently when I set F2 to 28FT all the rows(f4:h10) display data.


I big thanks in advance to anyone that can help me.

 

[xld]

Use this array formula for F4


=IF(ISERROR(SMALL(IF($A$4:$A$10=$F$2,ROW($A$4:$A$10)-ROW($A$4)+1),ROW(A1))),"",

INDEX(B$4:B$10,SMALL(IF($A$4:$A$10=$F$2,ROW($A$4:$A$10)-ROW($A$4)+1),ROW(A1))))


and copy down and across