You could have the various tables with lookup and then cull out the best
one. A formula or macro could do this.

--
Don Guillett
SalesAid Software

"Crys" wrote in message
...
I'm trying to develop a shipping calculator to compare courier rates.
Using
shipping rates given to you from different couriers (user enters rates) ,
excelsheet will calculate best rate for a given weight,destination and
origin.