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 ha_m...@yahoo.co.id
[belajar-excel]<belajar-excel@yahoogroups.com> 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
