How to find a number (similar to Vlookup but not exactly)

[lee478]

Hi,

I would like to run a iteration that takes a number from column B and searches where it fits on column A.

For example:

Column A Column B
3
10 18
34 22
56 24
lets say i is for incrementing on column B
j is for incrementing on clolumn B

So I would like to take 18 and search where it fits so it would be between row 2 and 3.
and then i++ on column B so it would be 22 and again do the same thing from the top on column A to bottom. so j has to be reset to 0 but I dunno how to do that reset.

Please help me out!!
Thanks!!!!

[millz]

Why not just copy what's in B, into A? and then do a sort.

[lee478]

SOLVED was stupid question. Thanks though!