INDEX + MATCH - Get Digital Help

Get Digital Help

<a href="//pixfuture-d.openx.net/w/1.0/rc?cs=5e204d84f8&cb=INSERT_RANDOM_NUMBER_HERE" ><img src="//pixfuture-d.openx.net/w/1.0/ai?auid=538803744&cs=5e204d84f8&cb=INSERT_RANDOM_NUMBER_HERE" border="0" alt=""></a>

Archive for INDEX + MATCH

INDEX and MATCH – multiple criteria and multiple results

The formula in cell C14 returns multiple values from column Item. It uses multiple criteria specified in C12:C13 and applied […]

INDEX MATCH – Case sensitive

The picture above demonstrates a formula in cell F3 that allows you to look up a value in column B […]

INDEX MATCH – multiple results

The array formula in cell E6 extracts values from column C when the corresponding value in column B matches the […]

INDEX MATCH with multiple criteria

The formula demonstrated in cell D13 is a regular formula, most people prefer a regular formula over an array formula […]

Formula categories

Index and Match

String manipulation

Welcome! I am Oscar and here to help you! Feel free to comment and ask excel questions.
Don´t forget to add my RSS feed and subscribe to new blog articles by email.
Free Blog Emails

Email
Search website

.wdpu-container{position:fixed!important}.wdpu-container .wdpu-msg{position:fixed!important} img.wp-smiley, img.emoji { display: inline !important; border: none !important; box-shadow: none !important; height: 1em !important; width: 1em !important; margin: 0 .07em !important; vertical-align: -0.1em !important; background: none !important; padding: 0 !important; } .fEbIFPUgqJxw-bg{display:none;position:fixed;z-index:100;top:0;left:0;width:100%;height:100%;background:#000;background:rgba(0,0,0,.75)}.fEbIFPUgqJxw{visibility:hidden;position:fixed;z-index:101;top:100px;right:0;left:0;max-width:640px;margin-right:auto;margin-left:auto;background:#fff;-webkit-box-shadow:0 3px 5px 2px rgba(0,0,0,.25);box-shadow:0 3px 5px 2px rgba(0,0,0,.25);font-family:Arial,Helvetica,sans-serif}.fEbIFPUgqJxw-default,.fEbIFPUgqJxw-ok{padding:30px 30px 15px}.fEbIFPUgqJxw-image{overflow:hidden;position:relative;width:100%}.fEbIFPUgqJxw-image .fEbIFPUgqJxw-left{position:absolute;top:0;left:0;width:50%;height:100%}.fEbIFPUgqJxw-image .fEbIFPUgqJxw-right{float:right;width:50%;padding:30px}.fEbIFPUgqJxw.small{width:200px;margin-left:-140px}.fEbIFPUgqJxw.medium{width:400px;margin-left:-240px}.fEbIFPUgqJxw.large{width:600px;margin-left:-340px}.fEbIFPUgqJxw.xlarge{width:800px;margin-left:-440px}.close-fEbIFPUgqJxw{display:inline-block;position:absolute;top:15px;right:15px;width:30px;height:30px;color:#bbb;font-size:32px;font-weight:700;line-height:30px;text-align:center;cursor:pointer;-webkit-transition:.3s;transition:.3s}.close-fEbIFPUgqJxw:hover{color:#252b37}.fEbIFPUgqJxw h1{margin-bottom:15px;padding:0 30px;color:#252b37;font-size:28px;line-height:1.25;text-align:center}.fEbIFPUgqJxw-right h1{padding:0 30px 0 0;text-align:left}.fEbIFPUgqJxw p{margin-bottom:15px;color:#333745;font-size:14px}.fEbIFPUgqJxw p a{color:#ff6160}.fEbIFPUgqJxw-right .close-modal,.fEbIFPUgqJxw-footer .close-modal{padding:15px!important;border-radius:0!important;background-color:#ff6160;font-size:14px;letter-spacing:2px!important;-webkit-transition:.3s;transition:.3s}.fEbIFPUgqJxw-right .close-modal:hover,.fEbIFPUgqJxw-footer .close-modal:hover{background-color:#252b37!important}.fEbIFPUgqJxw-footer .grey-button-modal{margin-right:15px;background-color:#a5a5a5}.fEbIFPUgqJxw-footer{display:block;padding:15px 30px;background-color:#eff4f7;text-align:right}@media only screen and (max-width:640px){.fEbIFPUgqJxw{right:5%;left:5%;max-width:90%}.fEbIFPUgqJxw-default{padding:20px}.fEbIFPUgqJxw-image .fEbIFPUgqJxw-left{width:100%;height:250px}.fEbIFPUgqJxw-image .fEbIFPUgqJxw-right{float:left;width:100%;margin-top:250px;padding:20px}.fEbIFPUgqJxw h1{margin-bottom:10px;font-size:20px}.fEbIFPUgqJxw-right h1{padding:0}.fEbIFPUgqJxw p{margin-bottom:10px}.close-fEbIFPUgqJxw{color:#fcfcfc;background-color:#252b37}.close-fEbIFPUgqJxw:hover{color:#252b37;background-color:#fcfcfc}.fEbIFPUgqJxw-footer{padding:15px 20px}}@media only screen and (max-width:480px){.fEbIFPUgqJxw-image .fEbIFPUgqJxw-left{height:200px}.fEbIFPUgqJxw-image .fEbIFPUgqJxw-right{margin-top:200px}.fEbIFPUgqJxw-footer{text-align:center}.fEbIFPUgqJxw-footer .close-modal{width:80%;margin:5px 10%}}.mailster-embeded-form body{background:0;padding:0;margin:0}.mailster-embeded-form .mailster-form-body{padding:5px !important;margin:auto !important}.mailster-form-wrap{max-width:100%;max-height:95%;min-width:100px;-webkit-overflow-scrolling:touch}.mailster-form{margin-bottom:20px;position:relative}.mailster-form:before{content:"";position:absolute;display:block;height:100%;width:100%;z-index:1;background-repeat:no-repeat;background-position:center center;background-size:20px 20px;background-image:url('https://www.get-digital-help.com/wp-content/plugins/mailster/assets/css/../img/loading.gif');visibility:hidden;opacity:0;-webkit-transition:opacity .15s ease-in-out;-moz-transition:opacity .15s ease-in-out;-ms-transition:opacity .15s ease-in-out;-o-transition:opacity .15s ease-in-out;transition:opacity .15s ease-in-out}.mailster-form.loading:before{opacity:1;visibility:visible}@media only screen and (-webkit-min-device-pixel-ratio:2),only screen and (min-resolution:192dpi){.mailster-form:before{background-image:url('https://www.get-digital-help.com/wp-content/plugins/mailster/assets/css/../img/loading_2x.gif')}}.mailster-form:after,.mailster-form-fields:after{content:".";visibility:hidden;display:block;height:0;clear:both}.mailster-form,.mailster-form .input,.mailster-form .mailster-form-info{width:100%;-webkit-box-sizing:border-box;-moz-box-sizing:border-box;box-sizing:border-box}.mailster-embeded-form .mailster-form{margin-bottom:3px}.mailster-form .mailster-wrapper{position:relative;margin-bottom:2px;-webkit-transition:opacity .15s ease-in-out;-moz-transition:opacity .15s ease-in-out;-ms-transition:opacity .15s ease-in-out;-o-transition:opacity .15s ease-in-out;transition:opacity .15s ease-in-out}.mailster-form.loading .mailster-wrapper{opacity:.2}.mailster-form textarea.input{resize:vertical;height:150px}.mailster-form li{list-style:none !important;margin-left:0;padding-left:0}span.mailster-required{font-size:120%;font-weight:700;color:#bf4d4d}.mailster-lists-wrapper ul{list-style:none;margin-left:0;padding-left:0}.mailster-lists-wrapper ul li{margin-left:0}.mailster-list-description{color:inherit;display:block;margin-left:25px;font-size:.8em}.mailster-form-info{height:0;border-radius:2px;padding:5px;margin-bottom:4px;color:#fff;padding:9px 16px;-webkit-transition:all .2s;-moz-transition:all .2s;transition:all .2s;-webkit-transform:scale(0);-moz-transform:scale(0);-ms-transform:scale(0);transform:scale(0)}.mailster-form.loading .mailster-form-info{opacity:0}.mailster-form-info a{color:#fff}.mailster-form-info.success,.mailster-form-info.error{display:block;height:100%;-webkit-transform:scale(1);-moz-transform:scale(1);-ms-transform:scale(1);transform:scale(1)}.mailster-form .error input,.mailster-form .error select,.mailster-form .error textarea{outline:2px solid #bf4d4d;outline-offset:0}.mailster-form-info.error{background:#bf4d4d}.mailster-form-info.success{background-color:#6fbf4d;text-align:center}.mailster-form-info ul,.mailster-form .mailster-form-info p{margin:0;padding:0}.mailster-form-info ul li{color:inherit;margin-left:0}.mailster-submit-wrapper{margin-top:6px}.mailster-form .submit-button{cursor:pointer}.mailster-form .submit-button:focus{outline:0}