Lookup by multiple criteria

Originally Posted by teylyn

where is the connection between 45 kgs and Adelaide's value of 1.60?

there's one element missing here. Your first row maybe needs to show the weight categories. What are they? This would all be easier if you posted your data in a workbook instead of pasting it in a post.

Saves a heck of a lot of time!

Edit: trying to interpret your data, I've come up with this. See what you can do with it

cheers

Thanks so much I think you have the idea, I've attached the complete sheet so you can see, if you look at the second tab entitled quote screen what I'm trying to do is create a drop down list and then this looks up the corresponding rate based on the weight breakpoint to return the appropraite rate so I can use this for my other caluculations.

Many Many thanks !

Ian