Find Next whole number in Range

[ManUBlueJay]

I have a number in A1.
I want that number to be found in range B1:B100
Then I need to find the next whole number after that. The Cells between is my dynamic range.
Example: A1 has 25

B1 to B10:
B1 12c
12d
B3 25
37b
12c
13d
B7 47
42a
51b
B10 12

So I want my Range to be B4:B6

 

[jasonb75]

Is this what you mean?

Book1
	A	B
1	25	12c
2	37b	12d
3	12c	25
4	13d	37b
5		12c
6		13d
7		47
8		42a
9		51b
10		12
Sheet1

Cell Formulas
Range	Formula
A2:A4	A2	=INDEX($B$1:$B$10,MATCH($A$1,$B$1:$B$10,0)+1):INDEX($B$1:$B$10,AGGREGATE(15,6,ROW($B$1:$B$10)/(ROW($B$1:$B$10)>MATCH($A$1,$B$1:$B$10,0))/ISNUMBER($B$1:$B$10),1)-1)
Dynamic array formulas.

 

[ManUBlueJay]

Brilliant, I usually work with offset and was hoping to just be able to offset the result. I am looking for what you did offset by one col.

 

[jasonb75]

If I understand correctly then you just need to change the INDEX ranges (both of them) from column B to column C.
Being a volatile function offset is best avoided where possible, what you are doing should be possible with offset but it would be a longer, less efficient formula.

 

[ManUBlueJay]

My Lookup criteria remains in B. The cells that I need in my range are in C

 

[jasonb75]

Then you do just need to change the index ranges from B to C.
The index range is the result, the remaining ranges in column B are the lookup criteria based on A1.

 

[ManUBlueJay]

Thank you. I have now solved it, and have a better understanding of the Index function. Thank you for that