How do I achieve the following using Dropdown/List or functions.
The scenario is that if I choose Type=Kg then I should get result based on Kg and Vice versa
Sample.xls file attached for reference.
TYPE RANGE RATE
Kg 1 - 10 $5
11 - 50 $15
51 - 70 $20
>100 $50
Lbs 2.2 - 22 $5
21 - 55.5 $15
75 - 110 $20
>300 $50
Bookmarks