=IF(C16="VIP",VLOOKUP(MID(B16,2,3),$E$23:$H$27,2),IF(C16="EXECUTIVE",VLOOKU P(MID(B16,2,3),$E$23:$H$27,3),VLOOKUP(MID(B16,2,3),$E$23:$H$27,4)))
Mungkin seperti ini If(kolom kelas = vip, hlookup(mid(xxxx,1,3),if(kolom kelas = ekonomi,hlookup(mid(xxx,1,3),dst