Lookup Multi Kriteria

Dede Sulaeman

unread,

Nov 9, 2020, 2:57:55 AM11/9/20

to milis-bel...@googlegroups.com

Dear Be-Exceller,

Mohon masukannya terkait formula dikolom M.

agar lebih simple,bagaimana menyusun formulanya?

atau mungkin tabel acuannya yg perlu disusun ulang karena kode item bisa lebih dari 7 di kasus-kasus tertentu.

Salam,

DD

Lookup Multi Kriteria.xlsx

Abu Abdillaah

unread,

Nov 13, 2020, 1:57:47 AM11/13/20

to Dede Sulaeman, milis Belajar-Excel

Dear Pak DD

Coba dikolom M pakai rumus ini Pak

=INDEX(H4:H24,MATCH(J4&K4&L4,F4:F24&E4:E24&G4:G24,0))

Apakah sudah sesuai yang diharapkan?

Suwun,

Jatmiko

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to milis-belajar-e...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CALXAUEaks%3DDW76pyGBS04bqm0Fwh65Y0Z45u5i4R6vH6%2BkCdow%40mail.gmail.com.

Dede Sulaeman

unread,

Nov 16, 2020, 9:56:29 PM11/16/20

to Abu Abdillaah, milis Belajar-Excel

Dear Pak Jatmiko,

Maaf slow respon karena kegiatan belakangan agak sibuk.

pertanyaannya ada di sheet 2 pak.

Isinya sudah saya buat manual (itu yg benar)

untuk isian formula di sheet 2 yang sekiranya simpel adakah?

Salam,

DD

Lookup Multi Kriteria.xlsx

Reply all

Reply to author

Forward