Julian date - find next highest date/number

  • Thread starter Thread starter jchick0909
  • Start date Start date
J

jchick0909

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!!!
 
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
 
Back
Top