i'm jai krishnan im having a big problem in excel
1. in column A i'm having set of numbers in Column B also Having some set of numbers.
Now the result is first it has to match the numbers if no matches the the result should higher numbers Examples
Now matchfrom Column A
First Row 10 is there no match in Column B So next higher numbers is 15
Second Row 20 match20 is there in Column B so result will be 20
Third row 100 match100 no hundred inColumn B next Higher number is 956 like this i'm having around 35000 Rows So i want the result i want so pls tell me what is the Formula i can use to get the result.pls tell me the Formula