C6: {=OFFSET($C$16,MATCH(1,SEARCH($B$17:$B$19,B6),0),)}
hoặc: {=INDEX($C$17:$C$19,MATCH(1,SEARCH($B$17:$B$19,B6),0))}
E6: =SUMPRODUCT((LEFT(B6)=$B$17:$B$19)(N(ISNUMBER(SEARCH(MID(B6,2,1),$D$16:$E$16))))($D$17:$E$19D6))
F6: =SUMPRODUCT((LEFT(B6)=$B$17:$B$19)(--RIGHT(B6)=$F$17:$F$19)($G$17:$G$19E6))
Hoặc: >> Google: "biết rằng đơn giá được tra theo bảng tra thông tin" -
https://goo.gl/8Z77i6
