nitesh
New Member
I have a volume of pivotised data having headers as date,transporter,qty,destination. i have to lookup for freight rates which keep on changing very frequently on the basis of destination and the freight for a particular period. How can i do it through excel...
[pre]
[/pre]
[pre]
Code:
Date Transporter qty destination Freight
01.04.12 ABC 5 SILCHAR
05.04.12 CIPL 6 SILCHAR
06.04.12 XYZ 8 NAGAON
LOOKUP TABLE
DESTINATION 01.04.12 - 04.04.12 05.04.12
SILCHAR 200 220
NAGAON 300 320