Looking up data in a different worksheet based on criteria

Originally Posted by ConneXionLost

So, looking at your Brokerage tab, your fee for a minimum VFD would be $30.50 dollars. What about the $25 fee?

Ok. I went back and double checked everything. It does work as you had made the changes. I goofed and was looking at my original spreadsheet. I had copied in your formula for the Our Costs worksheet, but had forgotten to make the changes to the Brokerage worksheet. Once I did that, everything jives. Checked all the items manually and it is taking the next highest value (as exactly the Broker would do).

Thank you again for your time and patience!

Jeeperv6