Hello I making a project on rate sheet this is the brief. I am attaching one file called rata data in that I have mentioned the the destination and rate bands. Now my requirement is if destination is ARN and weight is 100Kgs then the rate should be 135 as per the rate band.
I have created 3 groups CISSCAN EUROPE USA AND under that all the destinations are mentioned.
Rate bands are mentioned in vertical and horizontal form use any one of them.
Now I am using IF function but it is not helping me any more as it does not include the text value.
If you do not understand feel free to ask.
Kindly find attachment for your reference.
Please help me......
Bookmarks