“14 20
12 25
10 35
8 50
4 65
I have a cell at let say E5 = to 30
the next number up is 35 and i want
to display the 10.
If E5 = to 55 than i want it to display
4
What is the formula for this?”

If the data is located in A2:B6, then use this formula:

=INDEX($A$2:$A$6,MATCH(E5,$B$2:$B$6)+1)

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.