Contoh Soal 1

 

Solusi :

* Ket 1 =vlookup(left(D2;2);$I$1:$K$4;2;0)

* Ket 2 =hlookup(right(D2;1);$M$1:$P$2;2;0)

* Biaya =vlookup(left(D2;2);$I$1:$K$1;3;0)