You're welcome - thanks for feeding back.

Pete

On Sep 8, 4:44*pm, Banshee wrote:
Thank you to both NBVC and Pete_UK.

Both solutions solved my problem. :)



"Banshee" wrote:
I have two sheets, X and Y set up as follows:

Y:
A1:B1 contain column headers
A2:A10 contain levels, 1 through 5 in random order
B2:B10 contain strings

Example:
Level String
1 Test1
4 Test2
3 Test3
2 Test4
1 Test5
2 Test6
5 Test7
3 Test8
1 Test9

X:
B2 contains a number, 1 through 5.

Example: 2

I need to populate X A4:A* with all entries Y B2:B10 where Y A2:A10 <= B2

Desired output would be:
Test1
Test4
Test5
Test6
Test9

I'm sorry if this is confusing, and I appreciate any help you can offer..

Thanks!- Hide quoted text -

- Show quoted text -