Function yang dibuat pak DD ini,=IFERROR(INDEX(Sheet2!$A$2:$H$7;MATCH(Sheet1!$D$4;Sheet2!$H$2:$H$7;0);ROW()-5);"")
lebih unggul karena hanya menggunakan 1 kolom bantu dan kombinasi 3 function yang ditulis 1 x dengan memanfaatkan hubungan antara kolom sumber data dan baris hasil dalam pengambilan kolom sumber datanya. Salam,HK ----- Forwarded Message ----- From: "Dede pmaho_l...@nabatisnack.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> To: belajar-excel@yahoogroups.com Sent: Monday, 4 May 2015, 14:40 Subject: RE: [belajar-excel] Link Sel [1 Attachment] DearMr Heru, Kloane perlu tambahan kolom bantu, sambil menunggu rekan-rekan yang lain yah.. Salam, DD From: heru mulyonohmulyon...@gmail.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com] Sent: 04 Mei 2015 13:46 To: belajar-excel@yahoogroups.com Subject: [belajar-excel] Link Sel [1 Attachment] Kpd, Yth Master Excel Mohon bantuan permasalahan saya, file terlampir terimkasih This e-mail and any files transmitted with it are confidential andintended solely for the use of the individual to whom it is addressed. If youhave received this email in error please send it back to the person that sentit to you. Any views or opinions presented are solely those of its author anddo not necessarily represent those of NABATI or any of its subsidiarycompanies. Unauthorized publication, use, dissemination, forwarding, printingor copying of this email and its associated attachments is strictly prohibited. #yiv2497260579 #yiv2497260579 -- #yiv2497260579ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2497260579 #yiv2497260579ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2497260579 #yiv2497260579ygrp-mkp #yiv2497260579hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2497260579 #yiv2497260579ygrp-mkp #yiv2497260579ads {margin-bottom:10px;}#yiv2497260579 #yiv2497260579ygrp-mkp .yiv2497260579ad {padding:0 0;}#yiv2497260579 #yiv2497260579ygrp-mkp .yiv2497260579ad p {margin:0;}#yiv2497260579 #yiv2497260579ygrp-mkp .yiv2497260579ad a {color:#0000ff;text-decoration:none;}#yiv2497260579 #yiv2497260579ygrp-sponsor #yiv2497260579ygrp-lc {font-family:Arial;}#yiv2497260579 #yiv2497260579ygrp-sponsor #yiv2497260579ygrp-lc #yiv2497260579hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2497260579 #yiv2497260579ygrp-sponsor #yiv2497260579ygrp-lc .yiv2497260579ad {margin-bottom:10px;padding:0 0;}#yiv2497260579 #yiv2497260579actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2497260579 #yiv2497260579activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2497260579 #yiv2497260579activity span {font-weight:700;}#yiv2497260579 #yiv2497260579activity span:first-child {text-transform:uppercase;}#yiv2497260579 #yiv2497260579activity span a {color:#5085b6;text-decoration:none;}#yiv2497260579 #yiv2497260579activity span span {color:#ff7900;}#yiv2497260579 #yiv2497260579activity span .yiv2497260579underline {text-decoration:underline;}#yiv2497260579 .yiv2497260579attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2497260579 .yiv2497260579attach div a {text-decoration:none;}#yiv2497260579 .yiv2497260579attach img {border:none;padding-right:5px;}#yiv2497260579 .yiv2497260579attach label {display:block;margin-bottom:5px;}#yiv2497260579 .yiv2497260579attach label a {text-decoration:none;}#yiv2497260579 blockquote {margin:0 0 0 4px;}#yiv2497260579 .yiv2497260579bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2497260579 .yiv2497260579bold a {text-decoration:none;}#yiv2497260579 dd.yiv2497260579last p a {font-family:Verdana;font-weight:700;}#yiv2497260579 dd.yiv2497260579last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2497260579 dd.yiv2497260579last p span.yiv2497260579yshortcuts {margin-right:0;}#yiv2497260579 div.yiv2497260579attach-table div div a {text-decoration:none;}#yiv2497260579 div.yiv2497260579attach-table {width:400px;}#yiv2497260579 div.yiv2497260579file-title a, #yiv2497260579 div.yiv2497260579file-title a:active, #yiv2497260579 div.yiv2497260579file-title a:hover, #yiv2497260579 div.yiv2497260579file-title a:visited {text-decoration:none;}#yiv2497260579 div.yiv2497260579photo-title a, #yiv2497260579 div.yiv2497260579photo-title a:active, #yiv2497260579 div.yiv2497260579photo-title a:hover, #yiv2497260579 div.yiv2497260579photo-title a:visited {text-decoration:none;}#yiv2497260579 div#yiv2497260579ygrp-mlmsg #yiv2497260579ygrp-msg p a span.yiv2497260579yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2497260579 .yiv2497260579green {color:#628c2a;}#yiv2497260579 .yiv2497260579MsoNormal {margin:0 0 0 0;}#yiv2497260579 o {font-size:0;}#yiv2497260579 #yiv2497260579photos div {float:left;width:72px;}#yiv2497260579 #yiv2497260579photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2497260579 #yiv2497260579photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2497260579 #yiv2497260579reco-category {font-size:77%;}#yiv2497260579 #yiv2497260579reco-desc {font-size:77%;}#yiv2497260579 .yiv2497260579replbq {margin:4px;}#yiv2497260579 #yiv2497260579ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2497260579 #yiv2497260579ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2497260579 #yiv2497260579ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2497260579 #yiv2497260579ygrp-mlmsg select, #yiv2497260579 input, #yiv2497260579 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2497260579 #yiv2497260579ygrp-mlmsg pre, #yiv2497260579 code {font:115% monospace;}#yiv2497260579 #yiv2497260579ygrp-mlmsg * {line-height:1.22em;}#yiv2497260579 #yiv2497260579ygrp-mlmsg #yiv2497260579logo {padding-bottom:10px;}#yiv2497260579 #yiv2497260579ygrp-msg p a {font-family:Verdana;}#yiv2497260579 #yiv2497260579ygrp-msg p#yiv2497260579attach-count span {color:#1E66AE;font-weight:700;}#yiv2497260579 #yiv2497260579ygrp-reco #yiv2497260579reco-head {color:#ff7900;font-weight:700;}#yiv2497260579 #yiv2497260579ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2497260579 #yiv2497260579ygrp-sponsor #yiv2497260579ov li a {font-size:130%;text-decoration:none;}#yiv2497260579 #yiv2497260579ygrp-sponsor #yiv2497260579ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2497260579 #yiv2497260579ygrp-sponsor #yiv2497260579ov ul {margin:0;padding:0 0 0 8px;}#yiv2497260579 #yiv2497260579ygrp-text {font-family:Georgia;}#yiv2497260579 #yiv2497260579ygrp-text p {margin:0 0 1em 0;}#yiv2497260579 #yiv2497260579ygrp-text tt {font-size:120%;}#yiv2497260579 #yiv2497260579ygrp-vital ul li:last-child {border-right:none !important;}#yiv2497260579
Copy of Link Sel.xlsx
Description: MS-Excel 2007 spreadsheet