I have a cell lets say A1 in which it is calculated by goal seek a percentage number, and on the other hand I have a table that has a range of percentages for example 10% 20% 30%... 100% for each percentage there is a certain number designated to it i.e. 10%---2 20%----4 etc..
What I am trying to achieve is that by telling the computer look up the percentage value of A1 and look at the percentage rage in my table and put the number that matches with the return. I normally use an =Index(..match(..)) formula but in this case my problem is that the ammount that I can get on A1 is not a rounded ammount like 30% I can obtain numbers like 31%, 32% Is there a way I can set up in my frmula so that it may find the closest number in the table range.
So if on cell A1 I have 35% to look up 30% on the table, but if it is over 35% to use 40% and so on.
Thank you!!!