VBA: Return first 10 values with criteria

[JAnders]

On SHEET "States": I have column B with a list of states, Column D has a list of corresponding dollar amount already in descending order & column A is a list of zip codes.
On Sheet "Highest": I have a state listed in cell A1, for cells A6:A15 I want to return the first 10 values that appear in column A on Sheet "States", if column B matches Sheet "Highest" A1. Repeat for returning first 10 values from column D on Sheet "States" if column B matches Sheet "Highest" A1.



Hopefully that makes sense.

I appreciate the help

 

[Fluff]

How about
=INDEX(States!$A$2:$A$233,AGGREGATE(15,6,(ROW(States!$A$2:$A$233)-ROW(States!$A$2)+1)/(States!$B$2:$B$233=$A$1),ROWS($A$1:$A1)))
=INDEX(States!$D$2:$D$233,AGGREGATE(15,6,(ROW(States!$D$2:$D$233)-ROW(States!$D$2)+1)/(States!$B$2:$B$233=$A$1),ROWS($A$1:$A1)))

 

[JAnders]

^ much appreciated Fluff! worked like a champ!

 

[Fluff]

You're welcome & thanks for the feedback