Terimakasih Mas Ghozi
Kemarin saya coba pake INDIRECT
{=INDIRECT("Master!H"&SMALL(IF(Master!$B$2:$B$26=B$2,ROW(Master!$H$2:$H$26)),ROW(1:1)))}
Pada Selasa, 23 Juni 2020 07.47.01 WIB, HAIRUL ALAM <[email protected]>
menulis:
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
#yiv6677631740 -- #yiv6677631740ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6677631740
#yiv6677631740ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6677631740
#yiv6677631740ygrp-mkp #yiv6677631740hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6677631740 #yiv6677631740ygrp-mkp #yiv6677631740ads
{margin-bottom:10px;}#yiv6677631740 #yiv6677631740ygrp-mkp .yiv6677631740ad
{padding:0 0;}#yiv6677631740 #yiv6677631740ygrp-mkp .yiv6677631740ad p
{margin:0;}#yiv6677631740 #yiv6677631740ygrp-mkp .yiv6677631740ad a
{color:#0000ff;text-decoration:none;}#yiv6677631740 #yiv6677631740ygrp-sponsor
#yiv6677631740ygrp-lc {font-family:Arial;}#yiv6677631740
#yiv6677631740ygrp-sponsor #yiv6677631740ygrp-lc #yiv6677631740hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6677631740
#yiv6677631740ygrp-sponsor #yiv6677631740ygrp-lc .yiv6677631740ad
{margin-bottom:10px;padding:0 0;}#yiv6677631740 #yiv6677631740actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6677631740
#yiv6677631740activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6677631740
#yiv6677631740activity span {font-weight:700;}#yiv6677631740
#yiv6677631740activity span:first-child
{text-transform:uppercase;}#yiv6677631740 #yiv6677631740activity span a
{color:#5085b6;text-decoration:none;}#yiv6677631740 #yiv6677631740activity span
span {color:#ff7900;}#yiv6677631740 #yiv6677631740activity span
.yiv6677631740underline {text-decoration:underline;}#yiv6677631740
.yiv6677631740attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6677631740 .yiv6677631740attach div a
{text-decoration:none;}#yiv6677631740 .yiv6677631740attach img
{border:none;padding-right:5px;}#yiv6677631740 .yiv6677631740attach label
{display:block;margin-bottom:5px;}#yiv6677631740 .yiv6677631740attach label a
{text-decoration:none;}#yiv6677631740 blockquote {margin:0 0 0
4px;}#yiv6677631740 .yiv6677631740bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6677631740
.yiv6677631740bold a {text-decoration:none;}#yiv6677631740 dd.yiv6677631740last
p a {font-family:Verdana;font-weight:700;}#yiv6677631740 dd.yiv6677631740last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6677631740
dd.yiv6677631740last p span.yiv6677631740yshortcuts
{margin-right:0;}#yiv6677631740 div.yiv6677631740attach-table div div a
{text-decoration:none;}#yiv6677631740 div.yiv6677631740attach-table
{width:400px;}#yiv6677631740 div.yiv6677631740file-title a, #yiv6677631740
div.yiv6677631740file-title a:active, #yiv6677631740
div.yiv6677631740file-title a:hover, #yiv6677631740 div.yiv6677631740file-title
a:visited {text-decoration:none;}#yiv6677631740 div.yiv6677631740photo-title a,
#yiv6677631740 div.yiv6677631740photo-title a:active, #yiv6677631740
div.yiv6677631740photo-title a:hover, #yiv6677631740
div.yiv6677631740photo-title a:visited {text-decoration:none;}#yiv6677631740
div#yiv6677631740ygrp-mlmsg #yiv6677631740ygrp-msg p a
span.yiv6677631740yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6677631740
.yiv6677631740green {color:#628c2a;}#yiv6677631740 .yiv6677631740MsoNormal
{margin:0 0 0 0;}#yiv6677631740 o {font-size:0;}#yiv6677631740
#yiv6677631740photos div {float:left;width:72px;}#yiv6677631740
#yiv6677631740photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv6677631740
#yiv6677631740photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6677631740
#yiv6677631740reco-category {font-size:77%;}#yiv6677631740
#yiv6677631740reco-desc {font-size:77%;}#yiv6677631740 .yiv6677631740replbq
{margin:4px;}#yiv6677631740 #yiv6677631740ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6677631740 #yiv6677631740ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6677631740
#yiv6677631740ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6677631740
#yiv6677631740ygrp-mlmsg select, #yiv6677631740 input, #yiv6677631740 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6677631740
#yiv6677631740ygrp-mlmsg pre, #yiv6677631740 code {font:115%
monospace;}#yiv6677631740 #yiv6677631740ygrp-mlmsg *
{line-height:1.22em;}#yiv6677631740 #yiv6677631740ygrp-mlmsg #yiv6677631740logo
{padding-bottom:10px;}#yiv6677631740 #yiv6677631740ygrp-msg p a
{font-family:Verdana;}#yiv6677631740 #yiv6677631740ygrp-msg
p#yiv6677631740attach-count span {color:#1E66AE;font-weight:700;}#yiv6677631740
#yiv6677631740ygrp-reco #yiv6677631740reco-head
{color:#ff7900;font-weight:700;}#yiv6677631740 #yiv6677631740ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6677631740 #yiv6677631740ygrp-sponsor
#yiv6677631740ov li a {font-size:130%;text-decoration:none;}#yiv6677631740
#yiv6677631740ygrp-sponsor #yiv6677631740ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6677631740
#yiv6677631740ygrp-sponsor #yiv6677631740ov ul {margin:0;padding:0 0 0
8px;}#yiv6677631740 #yiv6677631740ygrp-text
{font-family:Georgia;}#yiv6677631740 #yiv6677631740ygrp-text p {margin:0 0 1em
0;}#yiv6677631740 #yiv6677631740ygrp-text tt {font-size:120%;}#yiv6677631740
#yiv6677631740ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6677631740
