Terimakasih Mas Ghozi
Pada Senin, 22 Juni 2020 20.50.57 WIB, ghozi alkatiri
[email protected] [belajar-excel] <[email protected]>
menulis:
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
#yiv5057098434 #yiv5057098434 -- #yiv5057098434ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5057098434
#yiv5057098434ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5057098434
#yiv5057098434ygrp-mkp #yiv5057098434hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5057098434 #yiv5057098434ygrp-mkp #yiv5057098434ads
{margin-bottom:10px;}#yiv5057098434 #yiv5057098434ygrp-mkp .yiv5057098434ad
{padding:0 0;}#yiv5057098434 #yiv5057098434ygrp-mkp .yiv5057098434ad p
{margin:0;}#yiv5057098434 #yiv5057098434ygrp-mkp .yiv5057098434ad a
{color:#0000ff;text-decoration:none;}#yiv5057098434 #yiv5057098434ygrp-sponsor
#yiv5057098434ygrp-lc {font-family:Arial;}#yiv5057098434
#yiv5057098434ygrp-sponsor #yiv5057098434ygrp-lc #yiv5057098434hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5057098434
#yiv5057098434ygrp-sponsor #yiv5057098434ygrp-lc .yiv5057098434ad
{margin-bottom:10px;padding:0 0;}#yiv5057098434 #yiv5057098434actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5057098434
#yiv5057098434activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5057098434
#yiv5057098434activity span {font-weight:700;}#yiv5057098434
#yiv5057098434activity span:first-child
{text-transform:uppercase;}#yiv5057098434 #yiv5057098434activity span a
{color:#5085b6;text-decoration:none;}#yiv5057098434 #yiv5057098434activity span
span {color:#ff7900;}#yiv5057098434 #yiv5057098434activity span
.yiv5057098434underline {text-decoration:underline;}#yiv5057098434
.yiv5057098434attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5057098434 .yiv5057098434attach div a
{text-decoration:none;}#yiv5057098434 .yiv5057098434attach img
{border:none;padding-right:5px;}#yiv5057098434 .yiv5057098434attach label
{display:block;margin-bottom:5px;}#yiv5057098434 .yiv5057098434attach label a
{text-decoration:none;}#yiv5057098434 blockquote {margin:0 0 0
4px;}#yiv5057098434 .yiv5057098434bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5057098434
.yiv5057098434bold a {text-decoration:none;}#yiv5057098434 dd.yiv5057098434last
p a {font-family:Verdana;font-weight:700;}#yiv5057098434 dd.yiv5057098434last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5057098434
dd.yiv5057098434last p span.yiv5057098434yshortcuts
{margin-right:0;}#yiv5057098434 div.yiv5057098434attach-table div div a
{text-decoration:none;}#yiv5057098434 div.yiv5057098434attach-table
{width:400px;}#yiv5057098434 div.yiv5057098434file-title a, #yiv5057098434
div.yiv5057098434file-title a:active, #yiv5057098434
div.yiv5057098434file-title a:hover, #yiv5057098434 div.yiv5057098434file-title
a:visited {text-decoration:none;}#yiv5057098434 div.yiv5057098434photo-title a,
#yiv5057098434 div.yiv5057098434photo-title a:active, #yiv5057098434
div.yiv5057098434photo-title a:hover, #yiv5057098434
div.yiv5057098434photo-title a:visited {text-decoration:none;}#yiv5057098434
div#yiv5057098434ygrp-mlmsg #yiv5057098434ygrp-msg p a
span.yiv5057098434yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5057098434
.yiv5057098434green {color:#628c2a;}#yiv5057098434 .yiv5057098434MsoNormal
{margin:0 0 0 0;}#yiv5057098434 o {font-size:0;}#yiv5057098434
#yiv5057098434photos div {float:left;width:72px;}#yiv5057098434
#yiv5057098434photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv5057098434
#yiv5057098434photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5057098434
#yiv5057098434reco-category {font-size:77%;}#yiv5057098434
#yiv5057098434reco-desc {font-size:77%;}#yiv5057098434 .yiv5057098434replbq
{margin:4px;}#yiv5057098434 #yiv5057098434ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5057098434 #yiv5057098434ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5057098434
#yiv5057098434ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5057098434
#yiv5057098434ygrp-mlmsg select, #yiv5057098434 input, #yiv5057098434 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5057098434
#yiv5057098434ygrp-mlmsg pre, #yiv5057098434 code {font:115%
monospace;}#yiv5057098434 #yiv5057098434ygrp-mlmsg *
{line-height:1.22em;}#yiv5057098434 #yiv5057098434ygrp-mlmsg #yiv5057098434logo
{padding-bottom:10px;}#yiv5057098434 #yiv5057098434ygrp-msg p a
{font-family:Verdana;}#yiv5057098434 #yiv5057098434ygrp-msg
p#yiv5057098434attach-count span {color:#1E66AE;font-weight:700;}#yiv5057098434
#yiv5057098434ygrp-reco #yiv5057098434reco-head
{color:#ff7900;font-weight:700;}#yiv5057098434 #yiv5057098434ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5057098434 #yiv5057098434ygrp-sponsor
#yiv5057098434ov li a {font-size:130%;text-decoration:none;}#yiv5057098434
#yiv5057098434ygrp-sponsor #yiv5057098434ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5057098434
#yiv5057098434ygrp-sponsor #yiv5057098434ov ul {margin:0;padding:0 0 0
8px;}#yiv5057098434 #yiv5057098434ygrp-text
{font-family:Georgia;}#yiv5057098434 #yiv5057098434ygrp-text p {margin:0 0 1em
0;}#yiv5057098434 #yiv5057098434ygrp-text tt {font-size:120%;}#yiv5057098434
#yiv5057098434ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5057098434
