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
IF(O4<=G3,G5,IF(AND(O4>G3,O4<=H3),H5,IF(AND(O4>H3,O4<=I3),I5,IF(AND(O4>I3,O4<=J3),J5,IF(AND(O4>J3,O4<=K3),K5,IF(AND(O4>K3,O4<=L3),L5,"Call For Quote"))))))
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
Bookmarks