|Hi guys, Hope you are doing good and hope you guys remember me.|
This is not a homework problem. I am 31 years old and not a good age to go to school. Actually, I have a habit of trying problems online/youtube to sharpen my excel skills and I came across this problem on https://www.scribd.com/. Link to the problem is: https://www.scribd.com/document/325...
Derby, I apologize I pasted the wrong formula. I was trying to say that we can use normal match function with 1 in 3rd argument to get the less than number but I do not want to have the less than but greater than number in this case. As I mentioned if we enter 25 or 30, it should return 2. So, what I tried was =MATCH(B1,A1:A8,1) and =MATCH(B1,A1:A8,1)+1, but didnt get what I was looking for
Mike, I was trying to find out the ways to get this done and thought to give it a shot without constraints, so i trying MATCH,LARGE,INDIRECT AND ROW, but with constraints, I was not able to do and then I came here to take assistance from you guys.
message edited by ArjunBadhan