Reverse the order of your table (i.e. switch row 17 & 19) so 1.5 is in A17
and .5 is in A19 then change the third argument of your first MATCH from 0 to
-1. That should do it.

"Kinghart" wrote:


I'm attaching a sample worksheet.. pls take a look and help me.


+-------------------------------------------------------------------+
|Filename: Copy of freight.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=126|
+-------------------------------------------------------------------+



--
Kinghart