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