Since you didn't say what error you got with the formula, it's hard to
know how to help - the syntax is fine, and it produces the results that
I believe you want.

The link shouldn't have had the last s:

http://www.mcgimpsey.com/excel/variablerate.html

In article ,
Paul wrote:

Thanks for taking time on this. Using your sugestion I get, the formula you
typed contains an error. Then under my cell

LOOKUP(lookup_value, lookup_vector, [result_vector])
LOOKUP(lookup_value, array)

Unable to open your link.