Vlookup with multiple conditions

[MROMAR]

I've attached a file.

What I basically need is a formula that would search through the Data tab and return a rate on the Daily Cost page in cell D3.

So it has to lookup the Destination, and the weight. Take for example Leaksdale as the destination, and 25,000 as the weight, in the Data table I need it to return, $1.90 because the weight is greater than 23999 but less than or equal 48,000.

If the destination was the same and the weight was 750, then the rate should be $12.99 since the weight greater than 499 and less than or equal to 999

If the weight was 150, meaning less than or equal to 250, then the rate that is returned should be $45.74

Any help is appreciated.

[BiIntel]

=VLOOKUP(B3,Costs!A1:M248,MATCH('Daily Data'!C3,Costs!A1:M1,0),0)

[twiggywales]

i think i have done this for you

Daily Cost.xlsx

i used this formula

Please Login or Register  to view this content.

[MROMAR]

i think i have done this for you

Attachment 189397

i used this formula

Please Login or Register  to view this content.

WOrked perfectly, thanks man

[twiggywales]

no problem glad to help