[belajar-excel] Lookup2

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

[belajar-excel] Lookup2

HAIRUL ALAM
Salam Para Master yang baik
Selamat siang semoga di siang ini selalu dalam keadaan baik dan sehat lahir bathin
Sedikit mengenai lookup sederhana yang terus terang saya bingung.
Bagaimana Rumusnya agar hasil lookup di kolom C sesuai data lookup dari kolom L sd M dengan criteria cell B2, seperti contoh data terlampir

Terimakasih Banyak Pencerahannya
AssalamualaikumHairul Alam

lookup 2.xlsx (12K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Lookup2

hendrik karnadi
Coba cari fungsi Small If (array formula) mbak Siti di database milis.
Salam,HK

Sent from Yahoo Mail on Android
 
  On Sun, Sep 15, 2019 at 13:07, HAIRUL ALAM [hidden email] [belajar-excel]<[hidden email]> wrote:      

Salam Para Master yang baik
Selamat siang semoga di siang ini selalu dalam keadaan baik dan sehat lahir bathin
Sedikit mengenai lookup sederhana yang terus terang saya bingung.
Bagaimana Rumusnya agar hasil lookup di kolom C sesuai data lookup dari kolom L sd M dengan criteria cell B2, seperti contoh data terlampir

Terimakasih Banyak Pencerahannya
AssalamualaikumHairul Alam  #yiv4261607264 #yiv4261607264 -- #yiv4261607264ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4261607264 #yiv4261607264ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4261607264 #yiv4261607264ygrp-mkp #yiv4261607264hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4261607264 #yiv4261607264ygrp-mkp #yiv4261607264ads {margin-bottom:10px;}#yiv4261607264 #yiv4261607264ygrp-mkp .yiv4261607264ad {padding:0 0;}#yiv4261607264 #yiv4261607264ygrp-mkp .yiv4261607264ad p {margin:0;}#yiv4261607264 #yiv4261607264ygrp-mkp .yiv4261607264ad a {color:#0000ff;text-decoration:none;}#yiv4261607264 #yiv4261607264ygrp-sponsor #yiv4261607264ygrp-lc {font-family:Arial;}#yiv4261607264 #yiv4261607264ygrp-sponsor #yiv4261607264ygrp-lc #yiv4261607264hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4261607264 #yiv4261607264ygrp-sponsor #yiv4261607264ygrp-lc .yiv4261607264ad {margin-bottom:10px;padding:0 0;}#yiv4261607264 #yiv4261607264actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4261607264 #yiv4261607264activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4261607264 #yiv4261607264activity span {font-weight:700;}#yiv4261607264 #yiv4261607264activity span:first-child {text-transform:uppercase;}#yiv4261607264 #yiv4261607264activity span a {color:#5085b6;text-decoration:none;}#yiv4261607264 #yiv4261607264activity span span {color:#ff7900;}#yiv4261607264 #yiv4261607264activity span .yiv4261607264underline {text-decoration:underline;}#yiv4261607264 .yiv4261607264attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4261607264 .yiv4261607264attach div a {text-decoration:none;}#yiv4261607264 .yiv4261607264attach img {border:none;padding-right:5px;}#yiv4261607264 .yiv4261607264attach label {display:block;margin-bottom:5px;}#yiv4261607264 .yiv4261607264attach label a {text-decoration:none;}#yiv4261607264 blockquote {margin:0 0 0 4px;}#yiv4261607264 .yiv4261607264bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4261607264 .yiv4261607264bold a {text-decoration:none;}#yiv4261607264 dd.yiv4261607264last p a {font-family:Verdana;font-weight:700;}#yiv4261607264 dd.yiv4261607264last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4261607264 dd.yiv4261607264last p span.yiv4261607264yshortcuts {margin-right:0;}#yiv4261607264 div.yiv4261607264attach-table div div a {text-decoration:none;}#yiv4261607264 div.yiv4261607264attach-table {width:400px;}#yiv4261607264 div.yiv4261607264file-title a, #yiv4261607264 div.yiv4261607264file-title a:active, #yiv4261607264 div.yiv4261607264file-title a:hover, #yiv4261607264 div.yiv4261607264file-title a:visited {text-decoration:none;}#yiv4261607264 div.yiv4261607264photo-title a, #yiv4261607264 div.yiv4261607264photo-title a:active, #yiv4261607264 div.yiv4261607264photo-title a:hover, #yiv4261607264 div.yiv4261607264photo-title a:visited {text-decoration:none;}#yiv4261607264 div#yiv4261607264ygrp-mlmsg #yiv4261607264ygrp-msg p a span.yiv4261607264yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4261607264 ..yiv4261607264green {color:#628c2a;}#yiv4261607264 .yiv4261607264MsoNormal {margin:0 0 0 0;}#yiv4261607264 o {font-size:0;}#yiv4261607264 #yiv4261607264photos div {float:left;width:72px;}#yiv4261607264 #yiv4261607264photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4261607264 #yiv4261607264photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4261607264 #yiv4261607264reco-category {font-size:77%;}#yiv4261607264 #yiv4261607264reco-desc {font-size:77%;}#yiv4261607264 .yiv4261607264replbq {margin:4px;}#yiv4261607264 #yiv4261607264ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4261607264 #yiv4261607264ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4261607264 #yiv4261607264ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4261607264 #yiv4261607264ygrp-mlmsg select, #yiv4261607264 input, #yiv4261607264 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4261607264 #yiv4261607264ygrp-mlmsg pre, #yiv4261607264 code {font:115% monospace;}#yiv4261607264 #yiv4261607264ygrp-mlmsg * {line-height:1.22em;}#yiv4261607264 #yiv4261607264ygrp-mlmsg #yiv4261607264logo {padding-bottom:10px;}#yiv4261607264 #yiv4261607264ygrp-msg p a {font-family:Verdana;}#yiv4261607264 #yiv4261607264ygrp-msg p#yiv4261607264attach-count span {color:#1E66AE;font-weight:700;}#yiv4261607264 #yiv4261607264ygrp-reco #yiv4261607264reco-head {color:#ff7900;font-weight:700;}#yiv4261607264 #yiv4261607264ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4261607264 #yiv4261607264ygrp-sponsor #yiv4261607264ov li a {font-size:130%;text-decoration:none;}#yiv4261607264 #yiv4261607264ygrp-sponsor #yiv4261607264ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4261607264 #yiv4261607264ygrp-sponsor #yiv4261607264ov ul {margin:0;padding:0 0 0 8px;}#yiv4261607264 #yiv4261607264ygrp-text {font-family:Georgia;}#yiv4261607264 #yiv4261607264ygrp-text p {margin:0 0 1em 0;}#yiv4261607264 #yiv4261607264ygrp-text tt {font-size:120%;}#yiv4261607264 #yiv4261607264ygrp-vital ul li:last-child {border-right:none !important;}#yiv4261607264  
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Lookup2 [1 Attachment]

ghozi alkatiri
In reply to this post by HAIRUL ALAM
 salah satu solusi yang bisa dicoba
formula array (CSE)  di C2
=IFERROR(INDIRECT("M"&SMALL(IF($L$2:$L$14=B$2,ROW($M$2:$M$14)),ROW(1:1))),"")

copy ke bawah 
wassalam
Ghozi Alkatiri

    Pada Minggu, 15 September 2019 13.07.32 WIB, HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    

Salam Para Master yang baik
Selamat siang semoga di siang ini selalu dalam keadaan baik dan sehat lahir bathin
Sedikit mengenai lookup sederhana yang terus terang saya bingung.
Bagaimana Rumusnya agar hasil lookup di kolom C sesuai data lookup dari kolom L sd M dengan criteria cell B2, seperti contoh data terlampir

Terimakasih Banyak Pencerahannya
AssalamualaikumHairul Alam  #yiv0609693258 #yiv0609693258 -- #yiv0609693258ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0609693258 #yiv0609693258ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0609693258 #yiv0609693258ygrp-mkp #yiv0609693258hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0609693258 #yiv0609693258ygrp-mkp #yiv0609693258ads {margin-bottom:10px;}#yiv0609693258 #yiv0609693258ygrp-mkp .yiv0609693258ad {padding:0 0;}#yiv0609693258 #yiv0609693258ygrp-mkp .yiv0609693258ad p {margin:0;}#yiv0609693258 #yiv0609693258ygrp-mkp .yiv0609693258ad a {color:#0000ff;text-decoration:none;}#yiv0609693258 #yiv0609693258ygrp-sponsor #yiv0609693258ygrp-lc {font-family:Arial;}#yiv0609693258 #yiv0609693258ygrp-sponsor #yiv0609693258ygrp-lc #yiv0609693258hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0609693258 #yiv0609693258ygrp-sponsor #yiv0609693258ygrp-lc .yiv0609693258ad {margin-bottom:10px;padding:0 0;}#yiv0609693258 #yiv0609693258actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0609693258 #yiv0609693258activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0609693258 #yiv0609693258activity span {font-weight:700;}#yiv0609693258 #yiv0609693258activity span:first-child {text-transform:uppercase;}#yiv0609693258 #yiv0609693258activity span a {color:#5085b6;text-decoration:none;}#yiv0609693258 #yiv0609693258activity span span {color:#ff7900;}#yiv0609693258 #yiv0609693258activity span .yiv0609693258underline {text-decoration:underline;}#yiv0609693258 .yiv0609693258attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0609693258 .yiv0609693258attach div a {text-decoration:none;}#yiv0609693258 .yiv0609693258attach img {border:none;padding-right:5px;}#yiv0609693258 .yiv0609693258attach label {display:block;margin-bottom:5px;}#yiv0609693258 .yiv0609693258attach label a {text-decoration:none;}#yiv0609693258 blockquote {margin:0 0 0 4px;}#yiv0609693258 .yiv0609693258bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0609693258 .yiv0609693258bold a {text-decoration:none;}#yiv0609693258 dd.yiv0609693258last p a {font-family:Verdana;font-weight:700;}#yiv0609693258 dd.yiv0609693258last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0609693258 dd.yiv0609693258last p span.yiv0609693258yshortcuts {margin-right:0;}#yiv0609693258 div.yiv0609693258attach-table div div a {text-decoration:none;}#yiv0609693258 div.yiv0609693258attach-table {width:400px;}#yiv0609693258 div.yiv0609693258file-title a, #yiv0609693258 div.yiv0609693258file-title a:active, #yiv0609693258 div.yiv0609693258file-title a:hover, #yiv0609693258 div.yiv0609693258file-title a:visited {text-decoration:none;}#yiv0609693258 div.yiv0609693258photo-title a, #yiv0609693258 div.yiv0609693258photo-title a:active, #yiv0609693258 div.yiv0609693258photo-title a:hover, #yiv0609693258 div.yiv0609693258photo-title a:visited {text-decoration:none;}#yiv0609693258 div#yiv0609693258ygrp-mlmsg #yiv0609693258ygrp-msg p a span.yiv0609693258yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0609693258 ..yiv0609693258green {color:#628c2a;}#yiv0609693258 .yiv0609693258MsoNormal {margin:0 0 0 0;}#yiv0609693258 o {font-size:0;}#yiv0609693258 #yiv0609693258photos div {float:left;width:72px;}#yiv0609693258 #yiv0609693258photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0609693258 #yiv0609693258photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0609693258 #yiv0609693258reco-category {font-size:77%;}#yiv0609693258 #yiv0609693258reco-desc {font-size:77%;}#yiv0609693258 .yiv0609693258replbq {margin:4px;}#yiv0609693258 #yiv0609693258ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0609693258 #yiv0609693258ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0609693258 #yiv0609693258ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0609693258 #yiv0609693258ygrp-mlmsg select, #yiv0609693258 input, #yiv0609693258 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0609693258 #yiv0609693258ygrp-mlmsg pre, #yiv0609693258 code {font:115% monospace;}#yiv0609693258 #yiv0609693258ygrp-mlmsg * {line-height:1.22em;}#yiv0609693258 #yiv0609693258ygrp-mlmsg #yiv0609693258logo {padding-bottom:10px;}#yiv0609693258 #yiv0609693258ygrp-msg p a {font-family:Verdana;}#yiv0609693258 #yiv0609693258ygrp-msg p#yiv0609693258attach-count span {color:#1E66AE;font-weight:700;}#yiv0609693258 #yiv0609693258ygrp-reco #yiv0609693258reco-head {color:#ff7900;font-weight:700;}#yiv0609693258 #yiv0609693258ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0609693258 #yiv0609693258ygrp-sponsor #yiv0609693258ov li a {font-size:130%;text-decoration:none;}#yiv0609693258 #yiv0609693258ygrp-sponsor #yiv0609693258ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0609693258 #yiv0609693258ygrp-sponsor #yiv0609693258ov ul {margin:0;padding:0 0 0 8px;}#yiv0609693258 #yiv0609693258ygrp-text {font-family:Georgia;}#yiv0609693258 #yiv0609693258ygrp-text p {margin:0 0 1em 0;}#yiv0609693258 #yiv0609693258ygrp-text tt {font-size:120%;}#yiv0609693258 #yiv0609693258ygrp-vital ul li:last-child {border-right:none !important;}#yiv0609693258  

=?UTF-8?b?Z2hvemkgMTUwOTIwMTkgbG9va3VwMi54bHN4?= (12K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Lookup2

HAIRUL ALAM
 Terimakasi Mas Ghozi
AssalamualaikumHairul Alam
    Pada Minggu, 15 September 2019 16.22.50 GMT+7, ghozi alkatiri [hidden email] [belajar-excel] <[hidden email]> menulis:

  

 salah satu solusi yang bisa dicoba
formula array (CSE)  di C2
=IFERROR(INDIRECT("M"&SMALL(IF($L$2:$L$14=B$2,ROW($M$2:$M$14)),ROW(1:1))),"")

copy ke bawah 
wassalam
Ghozi Alkatiri

    Pada Minggu, 15 September 2019 13.07...32 WIB, HAIRUL ALAM [hidden email] [belajar-excel] <[hidden email]> menulis:

  

Salam Para Master yang baik
Selamat siang semoga di siang ini selalu dalam keadaan baik dan sehat lahir bathin
Sedikit mengenai lookup sederhana yang terus terang saya bingung.
Bagaimana Rumusnya agar hasil lookup di kolom C sesuai data lookup dari kolom L sd M dengan criteria cell B2, seperti contoh data terlampir

Terimakasih Banyak Pencerahannya
AssalamualaikumHairul Alam      #yiv3626058003 #yiv3626058003 -- #yiv3626058003ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3626058003 #yiv3626058003ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3626058003 #yiv3626058003ygrp-mkp #yiv3626058003hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3626058003 #yiv3626058003ygrp-mkp #yiv3626058003ads {margin-bottom:10px;}#yiv3626058003 #yiv3626058003ygrp-mkp .yiv3626058003ad {padding:0 0;}#yiv3626058003 #yiv3626058003ygrp-mkp .yiv3626058003ad p {margin:0;}#yiv3626058003 #yiv3626058003ygrp-mkp .yiv3626058003ad a {color:#0000ff;text-decoration:none;}#yiv3626058003 #yiv3626058003ygrp-sponsor #yiv3626058003ygrp-lc {font-family:Arial;}#yiv3626058003 #yiv3626058003ygrp-sponsor #yiv3626058003ygrp-lc #yiv3626058003hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3626058003 #yiv3626058003ygrp-sponsor #yiv3626058003ygrp-lc .yiv3626058003ad {margin-bottom:10px;padding:0 0;}#yiv3626058003 #yiv3626058003actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3626058003 #yiv3626058003activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3626058003 #yiv3626058003activity span {font-weight:700;}#yiv3626058003 #yiv3626058003activity span:first-child {text-transform:uppercase;}#yiv3626058003 #yiv3626058003activity span a {color:#5085b6;text-decoration:none;}#yiv3626058003 #yiv3626058003activity span span {color:#ff7900;}#yiv3626058003 #yiv3626058003activity span .yiv3626058003underline {text-decoration:underline;}#yiv3626058003 .yiv3626058003attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3626058003 .yiv3626058003attach div a {text-decoration:none;}#yiv3626058003 .yiv3626058003attach img {border:none;padding-right:5px;}#yiv3626058003 .yiv3626058003attach label {display:block;margin-bottom:5px;}#yiv3626058003 .yiv3626058003attach label a {text-decoration:none;}#yiv3626058003 blockquote {margin:0 0 0 4px;}#yiv3626058003 .yiv3626058003bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3626058003 .yiv3626058003bold a {text-decoration:none;}#yiv3626058003 dd.yiv3626058003last p a {font-family:Verdana;font-weight:700;}#yiv3626058003 dd.yiv3626058003last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3626058003 dd.yiv3626058003last p span.yiv3626058003yshortcuts {margin-right:0;}#yiv3626058003 div.yiv3626058003attach-table div div a {text-decoration:none;}#yiv3626058003 div.yiv3626058003attach-table {width:400px;}#yiv3626058003 div.yiv3626058003file-title a, #yiv3626058003 div.yiv3626058003file-title a:active, #yiv3626058003 div.yiv3626058003file-title a:hover, #yiv3626058003 div.yiv3626058003file-title a:visited {text-decoration:none;}#yiv3626058003 div.yiv3626058003photo-title a, #yiv3626058003 div.yiv3626058003photo-title a:active, #yiv3626058003 div.yiv3626058003photo-title a:hover, #yiv3626058003 div.yiv3626058003photo-title a:visited {text-decoration:none;}#yiv3626058003 div#yiv3626058003ygrp-mlmsg #yiv3626058003ygrp-msg p a span.yiv3626058003yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3626058003 .yiv3626058003green {color:#628c2a;}#yiv3626058003 .yiv3626058003MsoNormal {margin:0 0 0 0;}#yiv3626058003 o {font-size:0;}#yiv3626058003 #yiv3626058003photos div {float:left;width:72px;}#yiv3626058003 #yiv3626058003photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3626058003 #yiv3626058003photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3626058003 #yiv3626058003reco-category {font-size:77%;}#yiv3626058003 #yiv3626058003reco-desc {font-size:77%;}#yiv3626058003 .yiv3626058003replbq {margin:4px;}#yiv3626058003 #yiv3626058003ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3626058003 #yiv3626058003ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3626058003 #yiv3626058003ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3626058003 #yiv3626058003ygrp-mlmsg select, #yiv3626058003 input, #yiv3626058003 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3626058003 #yiv3626058003ygrp-mlmsg pre, #yiv3626058003 code {font:115% monospace;}#yiv3626058003 #yiv3626058003ygrp-mlmsg * {line-height:1.22em;}#yiv3626058003 #yiv3626058003ygrp-mlmsg #yiv3626058003logo {padding-bottom:10px;}#yiv3626058003 #yiv3626058003ygrp-msg p a {font-family:Verdana;}#yiv3626058003 #yiv3626058003ygrp-msg p#yiv3626058003attach-count span {color:#1E66AE;font-weight:700;}#yiv3626058003 #yiv3626058003ygrp-reco #yiv3626058003reco-head {color:#ff7900;font-weight:700;}#yiv3626058003 #yiv3626058003ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3626058003 #yiv3626058003ygrp-sponsor #yiv3626058003ov li a {font-size:130%;text-decoration:none;}#yiv3626058003 #yiv3626058003ygrp-sponsor #yiv3626058003ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3626058003 #yiv3626058003ygrp-sponsor #yiv3626058003ov ul {margin:0;padding:0 0 0 8px;}#yiv3626058003 #yiv3626058003ygrp-text {font-family:Georgia;}#yiv3626058003 #yiv3626058003ygrp-text p {margin:0 0 1em 0;}#yiv3626058003 #yiv3626058003ygrp-text tt {font-size:120%;}#yiv3626058003 #yiv3626058003ygrp-vital ul li:last-child {border-right:none !important;}#yiv3626058003
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Lookup2

HAIRUL ALAM
In reply to this post by hendrik karnadi
 Terimakasih Pak Hendrik
SalamHairul Alam
    Pada Minggu, 15 September 2019 14.18.25 GMT+7, hendrik karnadi [hidden email] [belajar-excel] <[hidden email]> menulis:

  
Coba cari fungsi Small If (array formula) mbak Siti di database milis.

Salam,HK

Sent from Yahoo Mail on Android

  On Sun, Sep 15, 2019 at 13:07, HAIRUL ALAM [hidden email] [belajar-excel]<[hidden email]> wrote:    

Salam Para Master yang baik
Selamat siang semoga di siang ini selalu dalam keadaan baik dan sehat lahir bathin
Sedikit mengenai lookup sederhana yang terus terang saya bingung.
Bagaimana Rumusnya agar hasil lookup di kolom C sesuai data lookup dari kolom L sd M dengan criteria cell B2, seperti contoh data terlampir

Terimakasih Banyak Pencerahannya
AssalamualaikumHairul Alam
  #yiv6313499790 #yiv6313499790 -- #yiv6313499790ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6313499790 #yiv6313499790ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6313499790 #yiv6313499790ygrp-mkp #yiv6313499790hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6313499790 #yiv6313499790ygrp-mkp #yiv6313499790ads {margin-bottom:10px;}#yiv6313499790 #yiv6313499790ygrp-mkp .yiv6313499790ad {padding:0 0;}#yiv6313499790 #yiv6313499790ygrp-mkp .yiv6313499790ad p {margin:0;}#yiv6313499790 #yiv6313499790ygrp-mkp .yiv6313499790ad a {color:#0000ff;text-decoration:none;}#yiv6313499790 #yiv6313499790ygrp-sponsor #yiv6313499790ygrp-lc {font-family:Arial;}#yiv6313499790 #yiv6313499790ygrp-sponsor #yiv6313499790ygrp-lc #yiv6313499790hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6313499790 #yiv6313499790ygrp-sponsor #yiv6313499790ygrp-lc .yiv6313499790ad {margin-bottom:10px;padding:0 0;}#yiv6313499790 #yiv6313499790actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6313499790 #yiv6313499790activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6313499790 #yiv6313499790activity span {font-weight:700;}#yiv6313499790 #yiv6313499790activity span:first-child {text-transform:uppercase;}#yiv6313499790 #yiv6313499790activity span a {color:#5085b6;text-decoration:none;}#yiv6313499790 #yiv6313499790activity span span {color:#ff7900;}#yiv6313499790 #yiv6313499790activity span .yiv6313499790underline {text-decoration:underline;}#yiv6313499790 .yiv6313499790attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6313499790 .yiv6313499790attach div a {text-decoration:none;}#yiv6313499790 .yiv6313499790attach img {border:none;padding-right:5px;}#yiv6313499790 .yiv6313499790attach label {display:block;margin-bottom:5px;}#yiv6313499790 .yiv6313499790attach label a {text-decoration:none;}#yiv6313499790 blockquote {margin:0 0 0 4px;}#yiv6313499790 .yiv6313499790bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6313499790 .yiv6313499790bold a {text-decoration:none;}#yiv6313499790 dd.yiv6313499790last p a {font-family:Verdana;font-weight:700;}#yiv6313499790 dd.yiv6313499790last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6313499790 dd.yiv6313499790last p span.yiv6313499790yshortcuts {margin-right:0;}#yiv6313499790 div.yiv6313499790attach-table div div a {text-decoration:none;}#yiv6313499790 div.yiv6313499790attach-table {width:400px;}#yiv6313499790 div.yiv6313499790file-title a, #yiv6313499790 div.yiv6313499790file-title a:active, #yiv6313499790 div...yiv6313499790file-title a:hover, #yiv6313499790 div.yiv6313499790file-title a:visited {text-decoration:none;}#yiv6313499790 div.yiv6313499790photo-title a, #yiv6313499790 div.yiv6313499790photo-title a:active, #yiv6313499790 div.yiv6313499790photo-title a:hover, #yiv6313499790 div.yiv6313499790photo-title a:visited {text-decoration:none;}#yiv6313499790 div#yiv6313499790ygrp-mlmsg #yiv6313499790ygrp-msg p a span.yiv6313499790yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6313499790 .yiv6313499790green {color:#628c2a;}#yiv6313499790 .yiv6313499790MsoNormal {margin:0 0 0 0;}#yiv6313499790 o {font-size:0;}#yiv6313499790 #yiv6313499790photos div {float:left;width:72px;}#yiv6313499790 #yiv6313499790photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6313499790 #yiv6313499790photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6313499790 #yiv6313499790reco-category {font-size:77%;}#yiv6313499790 #yiv6313499790reco-desc {font-size:77%;}#yiv6313499790 .yiv6313499790replbq {margin:4px;}#yiv6313499790 #yiv6313499790ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6313499790 #yiv6313499790ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6313499790 #yiv6313499790ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6313499790 #yiv6313499790ygrp-mlmsg select, #yiv6313499790 input, #yiv6313499790 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6313499790 #yiv6313499790ygrp-mlmsg pre, #yiv6313499790 code {font:115% monospace;}#yiv6313499790 #yiv6313499790ygrp-mlmsg * {line-height:1.22em;}#yiv6313499790 #yiv6313499790ygrp-mlmsg #yiv6313499790logo {padding-bottom:10px;}#yiv6313499790 #yiv6313499790ygrp-msg p a {font-family:Verdana;}#yiv6313499790 #yiv6313499790ygrp-msg p#yiv6313499790attach-count span {color:#1E66AE;font-weight:700;}#yiv6313499790 #yiv6313499790ygrp-reco #yiv6313499790reco-head {color:#ff7900;font-weight:700;}#yiv6313499790 #yiv6313499790ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6313499790 #yiv6313499790ygrp-sponsor #yiv6313499790ov li a {font-size:130%;text-decoration:none;}#yiv6313499790 #yiv6313499790ygrp-sponsor #yiv6313499790ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6313499790 #yiv6313499790ygrp-sponsor #yiv6313499790ov ul {margin:0;padding:0 0 0 8px;}#yiv6313499790 #yiv6313499790ygrp-text {font-family:Georgia;}#yiv6313499790 #yiv6313499790ygrp-text p {margin:0 0 1em 0;}#yiv6313499790 #yiv6313499790ygrp-text tt {font-size:120%;}#yiv6313499790 #yiv6313499790ygrp-vital ul li:last-child {border-right:none !important;}#yiv6313499790