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