How to get my Freight rates from two tables?

Hello all,

This is a cross post from MrExcel.Com with no luck. It should be a simple question for some one good at Excel.

I need to get the FreightKey from the second table to the first table.

Please check the following link to get the sample work book.

https://drive.google.com/file/d/0B8-...ew?usp=sharing

I tried Index/Match with less than, greater than choices also Vlookup with approximate match. But I could not get the correct result.

I need to get the FreightKey according to their Weight and Mode of transport.

Thanks
CopperKnife

Hi. I assume that column K plays no part in this. Try this:

(NB I deleted most of the 65,000 rows to get a represenative sample of your data & to get it to fit on the site).