[milis-belajar-excel] Lookup Multi Kriteria

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[milis-belajar-excel] Lookup Multi Kriteria

Dede Sulaeman-3
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

--
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 [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CALXAUEaks%3DDW76pyGBS04bqm0Fwh65Y0Z45u5i4R6vH6%2BkCdow%40mail.gmail.com.

Lookup Multi Kriteria.xlsx (18K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [milis-belajar-excel] Lookup Multi Kriteria

Jatmiko
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

 

On Mon, Nov 9, 2020 at 2:57 PM Dede Sulaeman <[hidden email]> wrote:
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

--
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 [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CALXAUEaks%3DDW76pyGBS04bqm0Fwh65Y0Z45u5i4R6vH6%2BkCdow%40mail.gmail.com.

--
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 [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CACqMSfoAZ1d%2BcfpB%2BdzRiM9Bb-t%2BZxTwHepomccJW9USLz7BaQ%40mail.gmail.com.
Reply | Threaded
Open this post in threaded view
|

Re: [milis-belajar-excel] Lookup Multi Kriteria

Dede Sulaeman-3
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

Pada tanggal Jum, 13 Nov 2020 pukul 10.38 Abu Abdillaah <[hidden email]> menulis:
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

 

On Mon, Nov 9, 2020 at 2:57 PM Dede Sulaeman <[hidden email]> wrote:
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

--
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 [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CALXAUEaks%3DDW76pyGBS04bqm0Fwh65Y0Z45u5i4R6vH6%2BkCdow%40mail.gmail.com.

--
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 [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CALXAUEbB%2BPfk0K%2Bc_6gWhq5MpNOnWJnqa7pNJGpNHQynYRM2xA%40mail.gmail.com.

Lookup Multi Kriteria.xlsx (21K) Download Attachment