Looking up data in a different worksheet based on criteria

Originally Posted by ConneXionLost

Mods made to "Our Costs" tab, as well as mods (in yellow) to the "Brokerage" tab.

Hope that helps.

Cheers,

Thank you, it helps alot. The one thing I didn't mention though and from what I've read is that Excel tends to go with the closest lower match if it doesn't find an exact match.

Can I get Excel to use the next highest level.

For example, instead of using 93.50, have it use 102.50?

Thank you again for getting me on the right track.