thanks Colin, Pecoflyer for your time and suggestions/feedback.
Colin, yes i want to calculate charges in one, that is, i want to multiply the total in A9 by the associated charge, in the example 2.50. Approximate match does not return correct charge. Not clear on what you mean by re-arranging the order. I tried ascending and descending and neither works

Pecoflyer, thanks however formula is not giving the correct answer, so if a9 = 2549, from the charge table it would be 2549*2.5.
From To charge


0 500 3.50
501 999 3.00
1000 2999 2.50
3000 4999 2.00
5000 999999999 1.50

p.s. here is sample file

Attached Files

Book1.xlsx (8.2 KB, 12 views)