Calculate dollar amount paid if between a to and from amount

Originally Posted by ConneXionLost

Try this:

=IF(I4="","",IF(I4<C5,F5,VLOOKUP(I4,C5:G259,4,1)))

Works awesome thanks all for the help in the formula!