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

the n/a at the moment is you have none of those formulas in H4 you have

Formula:

=IF(D4="FE",INDEX(FEDEX_DOM_PRICE!B228:K302,MATCH(FEDEX_DOM_PRICE!B227:K227,FEDEX_DOM_PRICE!A228:A302),0),)

however nested
they look like this

Formula:

=IF(D4="FE",INDEX(FEDEX_DOM_PRICE!$B$228:$K$302,MATCH(G4,FEDEX_DOM_PRICE!$A$228:$A$302,-1),MATCH(B4,FEDEX_DOM_PRICE!$B$227:$K$227,0)),IF(D4="FSO",INDEX(FEDEX_DOM_PRICE!$B$151:$N$225,MATCH(G4,FEDEX_DOM_PRICE!$A$151:$A$225,-1),MATCH(B4,FEDEX_DOM_PRICE!$B$150:$N$150,0)),IF(D4="FPO",INDEX(FEDEX_DOM_PRICE!$B$3:$N$148,MATCH(G4,FEDEX_DOM_PRICE!$A$3:$A$148,-1),MATCH(B4,FEDEX_DOM_PRICE!$B$2:$N$2,0)),"none")))

but you still get n/a for the first one in your sample as

Formula:

=INDEX(FEDEX_DOM_PRICE!$B$228:$K$302,MATCH(G4,FEDEX_DOM_PRICE!$A$228:$A$302,-1),MATCH(B4,FEDEX_DOM_PRICE!$B$227:$K$227,0))

is giving n/a
that's because
,

Formula:

MATCH(B4,FEDEX_DOM_PRICE!$B$227:$K$227,0)

gives n/a
as the text in the range FEDEX_DOM_PRICE!$B$227:$K$227 is full of leading and trailing spaces and so will not match
so i removed them and nested the formula see attached

have you not read post #2 all the way through? the attached workbook is what you asked for

"FEDEX_DOM_PRICE!$B$227:$K$227 in your originl the text dh or whatever most had leading or trailing spaces
eg I27
actually in cell was DH followed by 5 spaces
for per kilo instead of actual from table just add to the end

Formula:

*IF(G4>=99,G4,1)