Julian date - find next highest date/number
 

Hello,

I need a quick answer,

i have cells with dates as numbers next to a number as below:


A B
1 34558
5 34678
6 34729
3 34836

I have a cell with a Refence number (ie 34800) - i need a formula that will
go to the next highest number (34836) and retun the value in column A (3)

Thanks for any help!!!

Julian date - find next highest date/number
 

Assuming your reference value is in cell C1, and that your data table
occupies A1:B4, use this formula in D1:

=INDEX(A1:A4,MATCH(C1,B1:B4)+1)

Hope this helps.

Pete

On Mar 20, 10:30*pm, jchick0909
wrote:
Hello,

I need a quick answer,

i have cells with dates as numbers next to a number as below:

A * * *B
1 * 34558
5 * 34678
6 * 34729
3 * 34836

I have a cell with a Refence number (ie 34800) *- i need a formula that will
go to the next highest number (34836) and retun the value in column A (3)

Thanks for any help!!!