I would like to see if there is a formula to do the following function. If you look at the attached picture I need cell A2 to display one of the numbers from cells C1 thru C11 based on what number is entered into cell A1. If cell A1 is 10.00 or less I need cell A2 to display what is in C1. If cell A1 is between 10.01 and 20.00 I need cell A2 to display what is in C2. If cell A1 is between 20.01 and 30.00 I need cell A2 to display what is in C3. This would need to keep going in the same pattern. Is there any kind of formula that could be put into cell A2 to accomplish this? Thanks for any help.
