Vlookup with nested if statments

**jamesstorx** · 08-10-2011, 12:31 PM

Hi Guys,

I must be missing something, and it's proably starring me in the face. I have the attached sheet. When the user selects the city and enters the weight I need to find the appropriate rate. I can get the correct rate using this

Please Login or Register  to view this content.

but I need that if statment to be associated to the city selected in O10.

Let me know if you need more info.

Thanks
-James

**Richard Buttrey** · 08-10-2011, 12:40 PM

Hi James,

Use a compound =INDEX(=MATCH()) formula instead i.e.

Please Login or Register  to view this content.

Regards

**NBVC** · 08-10-2011, 12:42 PM

Try:

=INDEX($G$5:$L$108,MATCH(O10,$C$5:$C$108,0),MATCH(TRUE,INDEX($G$3:$L$3>=O4,0),0))

This will go to 250 if say you input weight is less than 250 (e.g 150)