look up value in column

[JusCor]

I have a spreadsheet of data and I have one column sorted from highest to lowest number. From the top of my spreadsheet I want to search down this column till I get to the first instance of the number 1 or less, and then stop.

I can't use the value of 1 to search for, as sometimes the first number less than 1 might be 0.02, or 0.01, or .....

So using VBA, I can select the first cell, Q2, but how do I check the value of this cell =3,and if not, move on to Q3, Q4 etc.

Thanks,

[LauraGB]

You need a loop and to use offset to move you down a line.

Please Login or Register  to view this content.

[royUK]

lauraGB, please use Code Tags when posting code.

[royUK]

Try

Please Login or Register  to view this content.