di C5 sheet record formula array
=IFERROR(INDEX(Master!$H$13:$H$26,SMALL(IF($B$2=Master!$B$13:$B$26,ROW(Master!$B$13:$B$26)),ROW(1:1))-12),"")
copy ke bawah
Pada Senin, 22 Juni 2020 17.24.39 WIB, HAIRUL ALAM [email protected]
[belajar-excel] <[email protected]> menulis:
Salam Para Master BeExcelSelamat SoreSemoga dalam keadaan sehat semuanya
Bagaimana lookup
Jika pada sheet (Record) cell B2 dipilih sesuai kriteriamisalkan ELECTRICAL
maka data yang tampil pada tabel C5sd C9 sesuai data Sheet (Master)
bagaimanaformulanya atau code macronya
seperti file terlampir
TerimakasihHairul Alam
#yiv7564063271 #yiv7564063271 -- #yiv7564063271ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7564063271
#yiv7564063271ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7564063271
#yiv7564063271ygrp-mkp #yiv7564063271hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7564063271 #yiv7564063271ygrp-mkp #yiv7564063271ads
{margin-bottom:10px;}#yiv7564063271 #yiv7564063271ygrp-mkp .yiv7564063271ad
{padding:0 0;}#yiv7564063271 #yiv7564063271ygrp-mkp .yiv7564063271ad p
{margin:0;}#yiv7564063271 #yiv7564063271ygrp-mkp .yiv7564063271ad a
{color:#0000ff;text-decoration:none;}#yiv7564063271 #yiv7564063271ygrp-sponsor
#yiv7564063271ygrp-lc {font-family:Arial;}#yiv7564063271
#yiv7564063271ygrp-sponsor #yiv7564063271ygrp-lc #yiv7564063271hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7564063271
#yiv7564063271ygrp-sponsor #yiv7564063271ygrp-lc .yiv7564063271ad
{margin-bottom:10px;padding:0 0;}#yiv7564063271 #yiv7564063271actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7564063271
#yiv7564063271activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7564063271
#yiv7564063271activity span {font-weight:700;}#yiv7564063271
#yiv7564063271activity span:first-child
{text-transform:uppercase;}#yiv7564063271 #yiv7564063271activity span a
{color:#5085b6;text-decoration:none;}#yiv7564063271 #yiv7564063271activity span
span {color:#ff7900;}#yiv7564063271 #yiv7564063271activity span
.yiv7564063271underline {text-decoration:underline;}#yiv7564063271
.yiv7564063271attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7564063271 .yiv7564063271attach div a
{text-decoration:none;}#yiv7564063271 .yiv7564063271attach img
{border:none;padding-right:5px;}#yiv7564063271 .yiv7564063271attach label
{display:block;margin-bottom:5px;}#yiv7564063271 .yiv7564063271attach label a
{text-decoration:none;}#yiv7564063271 blockquote {margin:0 0 0
4px;}#yiv7564063271 .yiv7564063271bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7564063271
.yiv7564063271bold a {text-decoration:none;}#yiv7564063271 dd.yiv7564063271last
p a {font-family:Verdana;font-weight:700;}#yiv7564063271 dd.yiv7564063271last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7564063271
dd.yiv7564063271last p span.yiv7564063271yshortcuts
{margin-right:0;}#yiv7564063271 div.yiv7564063271attach-table div div a
{text-decoration:none;}#yiv7564063271 div.yiv7564063271attach-table
{width:400px;}#yiv7564063271 div.yiv7564063271file-title a, #yiv7564063271
div.yiv7564063271file-title a:active, #yiv7564063271
div.yiv7564063271file-title a:hover, #yiv7564063271 div.yiv7564063271file-title
a:visited {text-decoration:none;}#yiv7564063271 div.yiv7564063271photo-title a,
#yiv7564063271 div.yiv7564063271photo-title a:active, #yiv7564063271
div.yiv7564063271photo-title a:hover, #yiv7564063271
div.yiv7564063271photo-title a:visited {text-decoration:none;}#yiv7564063271
div#yiv7564063271ygrp-mlmsg #yiv7564063271ygrp-msg p a
span.yiv7564063271yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7564063271
.yiv7564063271green {color:#628c2a;}#yiv7564063271 .yiv7564063271MsoNormal
{margin:0 0 0 0;}#yiv7564063271 o {font-size:0;}#yiv7564063271
#yiv7564063271photos div {float:left;width:72px;}#yiv7564063271
#yiv7564063271photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv7564063271
#yiv7564063271photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7564063271
#yiv7564063271reco-category {font-size:77%;}#yiv7564063271
#yiv7564063271reco-desc {font-size:77%;}#yiv7564063271 .yiv7564063271replbq
{margin:4px;}#yiv7564063271 #yiv7564063271ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7564063271 #yiv7564063271ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7564063271
#yiv7564063271ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7564063271
#yiv7564063271ygrp-mlmsg select, #yiv7564063271 input, #yiv7564063271 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7564063271
#yiv7564063271ygrp-mlmsg pre, #yiv7564063271 code {font:115%
monospace;}#yiv7564063271 #yiv7564063271ygrp-mlmsg *
{line-height:1.22em;}#yiv7564063271 #yiv7564063271ygrp-mlmsg #yiv7564063271logo
{padding-bottom:10px;}#yiv7564063271 #yiv7564063271ygrp-msg p a
{font-family:Verdana;}#yiv7564063271 #yiv7564063271ygrp-msg
p#yiv7564063271attach-count span {color:#1E66AE;font-weight:700;}#yiv7564063271
#yiv7564063271ygrp-reco #yiv7564063271reco-head
{color:#ff7900;font-weight:700;}#yiv7564063271 #yiv7564063271ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7564063271 #yiv7564063271ygrp-sponsor
#yiv7564063271ov li a {font-size:130%;text-decoration:none;}#yiv7564063271
#yiv7564063271ygrp-sponsor #yiv7564063271ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7564063271
#yiv7564063271ygrp-sponsor #yiv7564063271ov ul {margin:0;padding:0 0 0
8px;}#yiv7564063271 #yiv7564063271ygrp-text
{font-family:Georgia;}#yiv7564063271 #yiv7564063271ygrp-text p {margin:0 0 1em
0;}#yiv7564063271 #yiv7564063271ygrp-text tt {font-size:120%;}#yiv7564063271
#yiv7564063271ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7564063271
