FREIGHT CALCULATOR - Having issue to next IF / Index / Match
Pls. help to achieve following calculus to derive "Freight" with Calculator sheet, as still facing problem with IF / Index / Match combination.
Attached is the file in excel 2010
1. Three product "FE", "FP" & "FS"
2. The PinCode & Zoning lookup is in sheet "FEDEX_DOM_CATEGORY"
3. The Pricing is in sheet "FEDEX_DOM_PRICE"
"FP" & "FS" Zoning
Regions IMS Zone
Mumbai DA
Pune DB
Ahmadabad DC
Rest of West DD
Bangalore DE
Hyderabad DF
Chennai DG
Rest of South DH
Delhi NCR DI
Rest of North DJ
Kolkata DK
Rest of East DL
North East DM
FedEx Economy ("FE") Zoning
Regions IMS zone
North 1 DA
North 2 DB
East 1 DC
East 2 DD
North East DE
Central DF
West 1 DG
West 2 DH
South 1 DI
South 2 DJ
Pls. correct / suggest way to combine the following and to get desired result, currently its showing me error #N/A
=IF(D28="FE",(INDEX(FEDEX_DOM_PRICE!B228:K302,MATCH(G28,FEDEX_DOM_PRICE!A228:A302,-1),(MATCH(B28,FEDEX_DOM_PRICE!B227:K227,0)))),("none"))
=IF(D28="FSO",(INDEX(FEDEX_DOM_PRICE!B151:N225,MATCH(G28,FEDEX_DOM_PRICE!A151:A225,-1),(MATCH(B28,FEDEX_DOM_PRICE!B150:N150,0)))),("none"))
=IF(D28="FPO",(INDEX(FEDEX_DOM_PRICE!B3:N148,MATCH(G28,FEDEX_DOM_PRICE!A3:A148,-1),(MATCH(B28,FEDEX_DOM_PRICE!B2:N2,0)))),("none"))
The above are the condition checks required for Freight.
Recent comments
5 years 42 weeks ago
6 years 28 weeks ago
6 years 40 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 49 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago