HOW TO ? - Having issue with INDEX / Match and to nest with IF

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.

Thanx Martin,

My apologies, the file upload had been reworked to formula that have been pasted in the thread.

I want to nest Three Conditions having "FE", "FSO", "FSP", having different price structure to different regions.

Yes, I got now.

Though I have not understood your last advice "FEDEX_DOM_PRICE!$B$227:$K$227 is full of leading and trailing spaces"

Further, I have noticed that a weight "99" and above "9999" are per Kg. weight but results is showing same as respective Table Value.

Should I have to insert a multiple value, such as " if value is >99 * match result., how to do that?

I am learning thus might raise you silly questions.... pardon me for same.