Vlookup

[michigancruiser]

rather then reporting the larger or equal value is is possible to only
report the next larger value?

lets say my table array (A1 through A3) has the following numbers

2
4
7

and my lookup values (B1 through B7)are
2
3
4
5
6
7
8


=VLOOKUP(B1,A$1:A$3,1)
=VLOOKUP(B2,A$1:A$3,1)
=VLOOKUP(B3,A$1:A$3,1) etc... would return
2
2
4
4
4
7
7
But what I need is
4
4
7
7
7
7
7
In other words the value of the VLOOKUP + one cell lower.
Is there anyway to do this?

Thanks for your help
Frank

 

[J.E. McGimpsey]

One way:

=INDEX($A$1:$A$3,MIN(MATCH(B1,$A$1:$A$3,1)+1,3))