Using the attached file, the formula that I currently have in cell A22 returns a result in cell A20 that exactly matches an amount in my data table. I want to be able to modify this formula to also have the ability to lookup an amount such as $1.20 and return $.10, the amount in Col C that relates to a value that cannot be higher than the amount entered (i.e. $1.25 is > $1.20 so $.25 cannot be returned, $1.10 is < $1.20, therefore $.10 is returned).
Question.xls