www.exceldemy.com
Open in
urlscan Pro
2606:4700:3034::6815:bfb
Public Scan
URL:
https://www.exceldemy.com/excel-address-function/
Submission: On April 05 via api from US — Scanned from DE
Submission: On April 05 via api from US — Scanned from DE
Form analysis 4 forms found in the DOM
GET https://www.exceldemy.com/
<form role="search" method="get" class="search-form" action="https://www.exceldemy.com/">
<input type="text" name="s" placeholder="Search" data-posttype="post">
<input type="hidden" name="post_type" value="post"> <button type="submit" class="btnsearch hideonmobile" aria-label="Search"><i class="rhicon rhi-search"></i></button>
</form>POST https://www.exceldemy.com/wp-comments-post.php
<form action="https://www.exceldemy.com/wp-comments-post.php" method="post" id="commentform" class="comment-form"><textarea id="comment" name="comment" cols="30" rows="10" aria-required="true" aria-label="comment"></textarea>
<div class="usr_re"><input id="author" type="text" value="" name="author" placeholder="Name"></div>
<div class="email_re"><input id="email" type="text" value="" name="email" placeholder="E-mail"></div>
<div class="site_re end"><input id="url" type="text" value="" name="url" placeholder="Website"></div>
<div class="clearfix"></div>
<p class="form-submit"><input name="submit" type="submit" id="submit" class="submit" value="Submit"> <input type="hidden" name="comment_post_ID" value="60891" id="comment_post_ID">
<input type="hidden" name="comment_parent" id="comment_parent" value="0">
</p>
<p style="display: none;"><input type="hidden" id="akismet_comment_nonce" name="akismet_comment_nonce" value="fef2c11ea1"></p>
<p style="display: none !important;"><label>Δ<textarea name="ak_hp_textarea" cols="45" rows="8" maxlength="100"></textarea></label><input type="hidden" id="ak_js_1" name="ak_js" value="170">
<script type="rocketlazyloadscript">document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() );</script>
</p>
</form>POST
<form class="cpro-form" method="post">
<input type="hidden" class="panel-settings" data-style_id="350964" data-section="configure"
value="{"enable_custom_cookies":"","enable_cookies_class":"","enable_adblock_detection":"","enable_visitors":"","visitor_type":"first-time","referrer_type":"hide-from","hide_custom_cookies":"","hide_cookies_class":"","show_for_logged_in":"1","hide_on_device":"","cookies_enabled":"1","conversion_cookie":"365","closed_cookie":"30","cookies_enabled_submit":"","enable_cookies_class_submit":"","conversion_cookie_submit":"90","cookies_enabled_closed":"","enable_cookies_class_closed":"","closed_cookie_new":"30"}"><input
type="hidden" class="panel-rulesets" data-style_id="350964" data-section="configure"
value="[{"name":"Ruleset 1","autoload_on_duration":"0","load_on_duration":1,"autoload_on_no_page_visit":false,"load_on_no_page_visit":1,"load_on_page_visit_type":"is-more-than","cp_show_note_page_view":"","modal_exit_intent":false,"autoload_on_scroll":"1","load_after_scroll":"35","inactivity":false,"inactivity_link":"","enable_after_post":false,"enable_custom_scroll":false,"enable_scroll_class":"","on_scroll_txt":"","show_cta_info":"","enable_custom_cookies":false,"enable_cookies_class":"","on_cookie_txt":"","hide_cta_link":"","enable_adblock_detection":false,"all_visitor_info":"","enable_visitors":"","visitor_type":"first-time","enable_referrer":"","referrer_type":"hide-from","display_to":"","hide_from":"","enable_scheduler":false,"enable_scheduler_txt":"","start_date":"","end_date":"","custom_cls_text_head":"","enable_custom_class":false,"copy_link_code_button":"Copy Link Code","copy_link_cls_code_button":"","custom_class":"","custom_cls_text":""}]">
<style id="cp_popup_style_350964" type="text/css">
.cp_style_350964 .cp-popup-content {
font-family: Verdana;
font-style: Normal;
font-weight: Normal;
}
.cp_style_350964 .cp-popup-content {
border-style: none;
border-color: #e1e1e1;
border-width: 1px 1px 1px 1px;
border-radius: 3px 3px 3px 3px;
mobile-breakpoint: 767;
}
.cp_style_350964 #panel-1-350964 .cp-target:hover {}
.cp_style_350964 #panel-1-350964 {}
.cp_style_350964 .cpro-overlay {
background: rgba(0, 0, 0, 0.8);
}
.cp_style_350964 .cp-popup-wrapper .cpro-overlay {
height: 400px;
}
.cp_style_350964 .cp-popup-content {
width: 600px;
height: 400px;
background-color: #fff;
}
@media (max-width: 767px) {
.cp_style_350964 .cp-popup-content {
border-style: none;
border-color: #e1e1e1;
border-width: 1px 1px 1px 1px;
border-radius: 3px 3px 3px 3px;
mobile-breakpoint: 767;
}
.cp_style_350964 #panel-1-350964 .cp-target:hover {}
.cp_style_350964 #panel-1-350964 {}
.cp_style_350964 .cpro-overlay {
background: rgba(0, 0, 0, 0.8);
}
.cp_style_350964 .cp-popup-wrapper .cpro-overlay {
height: 280px;
}
.cp_style_350964 .cp-popup-content {
width: 320px;
height: 280px;
background-color: #fff;
}
}
.cp_style_350964 .cp-popup .cpro-form .cp-form-input-field {
font-family: inherit;
font-style: inherit;
font-weight: inherit;
text-transform: none;
font-size: 13px;
letter-spacing: 0;
text-align: left;
color: #666;
background-color: #fff;
border-style: solid;
border-width: 1px 1px 1px 1px;
border-radius: 1px 1px 1px 1px;
border-color: #bbb;
active-border-color: #666;
padding: 0px 10px 0px 10px;
}
.cp_style_350964 #form_field-350964 .cp-target:hover {}
.cp_style_350964 #form_field-350964 placeholder {
color: #666;
}
.cp_style_350964 .cp-popup .cpro-form .cp-form-input-field input[type='radio'],
.cp_style_350964 .cp-popup .cpro-form .cp-form-input-field input[type='checkbox'] {
color: #666;
background-color: #fff;
}
.cp_style_350964 .cp-popup .cpro-form .cp-form-input-field:focus {
border-color: #666;
}
.cp_style_350964 .cp-popup .cpro-form .cp-form-input-field::-webkit-input-placeholder {
color: #666;
}
.cp_style_350964 .cp-popup .cpro-form .cp-form-input-field::-moz-placeholder {
color: #666;
}
.cp_style_350964 .cp-popup .cpro-form .pika-lendar table tbody button:hover {
background: #666;
}
.cp_style_350964 .cp-popup .cpro-form .pika-lendar table tbody .is-selected .pika-button {
background: #666;
box-shadow: inset 0 1px 3px #666;
}
.cp_style_350964 #form_field-350964 {}
@media (max-width: 767px) {
.cp_style_350964 .cp-popup .cpro-form .cp-form-input-field {
font-family: inherit;
font-style: inherit;
font-weight: inherit;
text-transform: none;
font-size: 11px;
letter-spacing: 0;
text-align: left;
color: #666;
background-color: #fff;
border-style: solid;
border-width: 1px 1px 1px 1px;
border-radius: 1px 1px 1px 1px;
border-color: #bbb;
active-border-color: #666;
padding: 0px 10px 0px 10px;
}
.cp_style_350964 #form_field-350964 .cp-target:hover {}
.cp_style_350964 #form_field-350964 placeholder {
color: #666;
}
.cp_style_350964 .cp-popup .cpro-form .cp-form-input-field input[type='radio'],
.cp_style_350964 .cp-popup .cpro-form .cp-form-input-field input[type='checkbox'] {
color: #666;
background-color: #fff;
}
.cp_style_350964 .cp-popup .cpro-form .cp-form-input-field:focus {
border-color: #666;
}
.cp_style_350964 .cp-popup .cpro-form .cp-form-input-field::-webkit-input-placeholder {
color: #666;
}
.cp_style_350964 .cp-popup .cpro-form .cp-form-input-field::-moz-placeholder {
color: #666;
}
.cp_style_350964 .cp-popup .cpro-form .pika-lendar table tbody button:hover {
background: #666;
}
.cp_style_350964 .cp-popup .cpro-form .pika-lendar table tbody .is-selected .pika-button {
background: #666;
box-shadow: inset 0 1px 3px #666;
}
.cp_style_350964 #form_field-350964 {}
}
.cp_style_350964 #cp_image-2-350964 .cp-target {
width: 285px;
height: 401px;
}
.cp_style_350964 #cp_image-2-350964 .cp-target:hover {}
.cp_style_350964 #cp_image-2-350964 .cp-target {
border-style: none;
}
.cp_style_350964 #cp_image-2-350964 .cp-target~.cp-field-shadow {
border-style: none;
}
.cp_style_350964 #cp_image-2-350964 .cp-target {
border-color: #757575;
}
.cp_style_350964 #cp_image-2-350964 .cp-target~.cp-field-shadow {
border-color: #757575;
}
.cp_style_350964 #cp_image-2-350964 .cp-target {
border-width: 1px 1px 1px 1px;
}
.cp_style_350964 #cp_image-2-350964 .cp-target~.cp-field-shadow {
border-width: 1px 1px 1px 1px;
}
.cp_style_350964 #cp_image-2-350964 .cp-target {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_image-2-350964 .cp-target~.cp-field-shadow {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_image-2-350964 .cp-target>.cp-close-link {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_image-2-350964 .cp-target>.cp-close-image {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_image-2-350964 .cp-target {}
.cp_style_350964 #cp_image-2-350964 .cp-target~.cp-field-shadow {}
.cp_style_350964 #cp_image-2-350964 .cp-rotate-wrap {
transform: rotate(0deg);
}
.cp_style_350964 #cp_image-2-350964 .cp-target:hover {}
.cp_style_350964 #cp_image-2-350964 .cp-target:hover~.cp-field-shadow {}
.cp_style_350964 #cp_image-2-350964 {
left: 0px;
top: 0px;
z-index: 2;
}
@media (max-width: 767px) {
.cp_style_350964 #cp_image-2-350964 .cp-target {
width: 142px;
height: 214px;
}
.cp_style_350964 #cp_image-2-350964 .cp-target:hover {}
.cp_style_350964 #cp_image-2-350964 .cp-target {
border-style: none;
}
.cp_style_350964 #cp_image-2-350964 .cp-target~.cp-field-shadow {
border-style: none;
}
.cp_style_350964 #cp_image-2-350964 .cp-target {
border-color: #757575;
}
.cp_style_350964 #cp_image-2-350964 .cp-target~.cp-field-shadow {
border-color: #757575;
}
.cp_style_350964 #cp_image-2-350964 .cp-target {
border-width: 1px 1px 1px 1px;
}
.cp_style_350964 #cp_image-2-350964 .cp-target~.cp-field-shadow {
border-width: 1px 1px 1px 1px;
}
.cp_style_350964 #cp_image-2-350964 .cp-target {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_image-2-350964 .cp-target~.cp-field-shadow {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_image-2-350964 .cp-target>.cp-close-link {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_image-2-350964 .cp-target>.cp-close-image {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_image-2-350964 .cp-target {}
.cp_style_350964 #cp_image-2-350964 .cp-target~.cp-field-shadow {}
.cp_style_350964 #cp_image-2-350964 .cp-rotate-wrap {
transform: rotate(0deg);
}
.cp_style_350964 #cp_image-2-350964 .cp-target:hover {}
.cp_style_350964 #cp_image-2-350964 .cp-target:hover~.cp-field-shadow {}
.cp_style_350964 #cp_image-2-350964 {
left: 0px;
top: 0px;
z-index: 2;
}
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target {
width: 45px;
height: 45px;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target:hover {}
.cp_style_350964 #cp_close_image-2-350964 .cp-target {
border-style: none;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target~.cp-field-shadow {
border-style: none;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target {
border-color: #757575;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target~.cp-field-shadow {
border-color: #757575;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target {
border-width: 1px 1px 1px 1px;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target~.cp-field-shadow {
border-width: 1px 1px 1px 1px;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target~.cp-field-shadow {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target>.cp-close-link {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target>.cp-close-image {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target {}
.cp_style_350964 #cp_close_image-2-350964 .cp-target~.cp-field-shadow {}
.cp_style_350964 #cp_close_image-2-350964 .cp-rotate-wrap {
transform: rotate(0deg);
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target:hover {}
.cp_style_350964 #cp_close_image-2-350964 .cp-target:hover~.cp-field-shadow {}
.cp_style_350964 #cp_close_image-2-350964 {
left: 577px;
top: -22px;
z-index: 3;
}
@media (max-width: 767px) {
.cp_style_350964 #cp_close_image-2-350964 .cp-target {
width: 45px;
height: 45px;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target:hover {}
.cp_style_350964 #cp_close_image-2-350964 .cp-target {
border-style: none;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target~.cp-field-shadow {
border-style: none;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target {
border-color: #757575;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target~.cp-field-shadow {
border-color: #757575;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target {
border-width: 1px 1px 1px 1px;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target~.cp-field-shadow {
border-width: 1px 1px 1px 1px;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target~.cp-field-shadow {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target>.cp-close-link {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target>.cp-close-image {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target {}
.cp_style_350964 #cp_close_image-2-350964 .cp-target~.cp-field-shadow {}
.cp_style_350964 #cp_close_image-2-350964 .cp-rotate-wrap {
transform: rotate(0deg);
}
.cp_style_350964 #cp_close_image-2-350964 .cp-target:hover {}
.cp_style_350964 #cp_close_image-2-350964 .cp-target:hover~.cp-field-shadow {}
.cp_style_350964 #cp_close_image-2-350964 {
left: 298px;
top: -22px;
z-index: 3;
}
}
.cp_style_350964 #cp_heading-2-350964 .cp-target {
font-family: Lato;
font-style: 700;
font-weight: 700;
font-size: 36px;
line-height: 1.13;
letter-spacing: 0px;
text-align: center;
color: #000000;
width: 279px;
height: 92px;
}
.cp_style_350964 #cp_heading-2-350964 .cp-target:hover {}
.cp_style_350964 #cp_heading-2-350964 .cp-rotate-wrap {
transform: rotate(0deg);
}
.cp_style_350964 #cp_heading-2-350964 {
left: 293.5px;
top: 89.5px;
z-index: 4;
}
@media (max-width: 767px) {
.cp_style_350964 #cp_heading-2-350964 .cp-target {
font-family: Lato;
font-style: 700;
font-weight: 700;
font-size: 26px;
line-height: 1.13;
letter-spacing: 0px;
text-align: center;
color: #000000;
width: 203px;
height: 68px;
}
.cp_style_350964 #cp_heading-2-350964 .cp-target:hover {}
.cp_style_350964 #cp_heading-2-350964 .cp-rotate-wrap {
transform: rotate(0deg);
}
.cp_style_350964 #cp_heading-2-350964 {
left: 58.5px;
top: 33px;
z-index: 4;
}
}
.cp_style_350964 #cp_paragraph-2-350964 .cp-target {
font-family: Lato;
font-style: Inherit;
font-weight: Inherit;
font-size: 18px;
line-height: 1.4;
letter-spacing: 0px;
text-align: center;
color: #000000;
width: 256px;
height: 56px;
}
.cp_style_350964 #cp_paragraph-2-350964 .cp-target:hover {}
.cp_style_350964 #cp_paragraph-2-350964 .cp-rotate-wrap {
transform: rotate(0deg);
}
.cp_style_350964 #cp_paragraph-2-350964 {
left: 302.5px;
top: 180.5px;
z-index: 5;
}
@media (max-width: 767px) {
.cp_style_350964 #cp_paragraph-2-350964 .cp-target {
font-family: Lato;
font-style: Inherit;
font-weight: Inherit;
font-size: 18px;
line-height: 1.4;
letter-spacing: 0px;
text-align: center;
color: #000000;
width: 276px;
height: 53px;
}
.cp_style_350964 #cp_paragraph-2-350964 .cp-target:hover {}
.cp_style_350964 #cp_paragraph-2-350964 .cp-rotate-wrap {
transform: rotate(0deg);
}
.cp_style_350964 #cp_paragraph-2-350964 {
left: 16.5px;
top: 100px;
z-index: 5;
}
}
.cp_style_350964 #cp_paragraph-3-350964 .cp-target {
font-family: Lato;
font-style: Inherit;
font-weight: Inherit;
font-size: 16px;
line-height: 1.6;
letter-spacing: 0px;
text-align: center;
color: #555;
width: 256px;
height: 29px;
}
.cp_style_350964 #cp_paragraph-3-350964 .cp-target:hover {}
.cp_style_350964 #cp_paragraph-3-350964 .cp-rotate-wrap {
transform: rotate(0deg);
}
.cp_style_350964 #cp_paragraph-3-350964 {
left: 305px;
top: 8px;
z-index: 6;
}
@media (max-width: 767px) {
.cp_style_350964 #cp_paragraph-3-350964 .cp-target {
font-family: Lato;
font-style: Inherit;
font-weight: Inherit;
font-size: 13px;
line-height: 1.6;
letter-spacing: 0px;
text-align: center;
color: #555;
width: 137px;
height: 19px;
}
.cp_style_350964 #cp_paragraph-3-350964 .cp-target:hover {}
.cp_style_350964 #cp_paragraph-3-350964 .cp-rotate-wrap {
transform: rotate(0deg);
}
.cp_style_350964 #cp_paragraph-3-350964 {
left: 91.5px;
top: 6px;
z-index: 6;
}
}
.cp_style_350964 #cp_email-3-350964 .cp-target {
width: 251px;
height: 45px;
}
.cp_style_350964 #cp_email-3-350964 .cp-target:hover {}
.cp_style_350964 #cp_email-3-350964 {
left: 307.5px;
top: 294.5px;
z-index: 7;
}
@media (max-width: 767px) {
.cp_style_350964 #cp_email-3-350964 .cp-target {
width: 277px;
height: 30px;
}
.cp_style_350964 #cp_email-3-350964 .cp-target:hover {}
.cp_style_350964 #cp_email-3-350964 {
left: 21px;
top: 191px;
z-index: 7;
}
}
.cp_style_350964 #cp_text-3-350964 .cp-target {
width: 251px;
height: 45px;
}
.cp_style_350964 #cp_text-3-350964 .cp-target:hover {}
.cp_style_350964 #cp_text-3-350964 {
left: 307.5px;
top: 246.5px;
z-index: 8;
}
@media (max-width: 767px) {
.cp_style_350964 #cp_text-3-350964 .cp-target {
width: 276px;
height: 30px;
}
.cp_style_350964 #cp_text-3-350964 .cp-target:hover {}
.cp_style_350964 #cp_text-3-350964 {
left: 21px;
top: 158px;
z-index: 8;
}
}
.cp_style_350964 #cp_button-3-350964 .cp-target {
font-family: Lato;
font-style: 700;
font-weight: 700;
font-size: 19px;
letter-spacing: 0px;
text-align: center;
color: #fff;
background: #3498DB;
width: 251px;
height: 50px;
padding: 0px 15px 0px 15px;
}
.cp_style_350964 #cp_button-3-350964 .cp-target:hover {
color: #fff;
background: #2980B9;
}
.cp_style_350964 #cp_button-3-350964 .cp-target {
border-style: none;
}
.cp_style_350964 #cp_button-3-350964 .cp-target~.cp-field-shadow {
border-style: none;
}
.cp_style_350964 #cp_button-3-350964 .cp-target {
border-color: #757575;
}
.cp_style_350964 #cp_button-3-350964 .cp-target~.cp-field-shadow {
border-color: #757575;
}
.cp_style_350964 #cp_button-3-350964 .cp-target {
border-width: 1px 1px 1px 1px;
}
.cp_style_350964 #cp_button-3-350964 .cp-target~.cp-field-shadow {
border-width: 1px 1px 1px 1px;
}
.cp_style_350964 #cp_button-3-350964 .cp-target {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_button-3-350964 .cp-target~.cp-field-shadow {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_button-3-350964 .cp-target>.cp-close-link {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_button-3-350964 .cp-target>.cp-close-image {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_button-3-350964 .cp-target {}
.cp_style_350964 #cp_button-3-350964 .cp-target~.cp-field-shadow {}
.cp_style_350964 #cp_button-3-350964 .cp-rotate-wrap {
transform: rotate(0deg);
}
.cp_style_350964 #cp_button-3-350964 .cp-target:hover {}
.cp_style_350964 #cp_button-3-350964 .cp-target:hover~.cp-field-shadow {}
.cp_style_350964 #cp_button-3-350964 {
left: 307.5px;
top: 343.5px;
z-index: 10;
}
@media (max-width: 767px) {
.cp_style_350964 #cp_button-3-350964 .cp-target {
font-family: Lato;
font-style: 700;
font-weight: 700;
font-size: 16px;
letter-spacing: 0px;
text-align: center;
color: #fff;
background: #3498DB;
width: 278px;
height: 40px;
padding: 0px 15px 0px 15px;
}
.cp_style_350964 #cp_button-3-350964 .cp-target:hover {
color: #fff;
background: #2980B9;
}
.cp_style_350964 #cp_button-3-350964 .cp-target {
border-style: none;
}
.cp_style_350964 #cp_button-3-350964 .cp-target~.cp-field-shadow {
border-style: none;
}
.cp_style_350964 #cp_button-3-350964 .cp-target {
border-color: #757575;
}
.cp_style_350964 #cp_button-3-350964 .cp-target~.cp-field-shadow {
border-color: #757575;
}
.cp_style_350964 #cp_button-3-350964 .cp-target {
border-width: 1px 1px 1px 1px;
}
.cp_style_350964 #cp_button-3-350964 .cp-target~.cp-field-shadow {
border-width: 1px 1px 1px 1px;
}
.cp_style_350964 #cp_button-3-350964 .cp-target {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_button-3-350964 .cp-target~.cp-field-shadow {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_button-3-350964 .cp-target>.cp-close-link {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_button-3-350964 .cp-target>.cp-close-image {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_button-3-350964 .cp-target {}
.cp_style_350964 #cp_button-3-350964 .cp-target~.cp-field-shadow {}
.cp_style_350964 #cp_button-3-350964 .cp-rotate-wrap {
transform: rotate(0deg);
}
.cp_style_350964 #cp_button-3-350964 .cp-target:hover {}
.cp_style_350964 #cp_button-3-350964 .cp-target:hover~.cp-field-shadow {}
.cp_style_350964 #cp_button-3-350964 {
left: 21px;
top: 226px;
z-index: 10;
}
}
.cp_style_350964 #cp_image-3-350964 .cp-target {
width: 181px;
height: 41px;
}
.cp_style_350964 #cp_image-3-350964 .cp-target:hover {}
.cp_style_350964 #cp_image-3-350964 .cp-target {
border-style: none;
}
.cp_style_350964 #cp_image-3-350964 .cp-target~.cp-field-shadow {
border-style: none;
}
.cp_style_350964 #cp_image-3-350964 .cp-target {
border-color: #757575;
}
.cp_style_350964 #cp_image-3-350964 .cp-target~.cp-field-shadow {
border-color: #757575;
}
.cp_style_350964 #cp_image-3-350964 .cp-target {
border-width: 1px 1px 1px 1px;
}
.cp_style_350964 #cp_image-3-350964 .cp-target~.cp-field-shadow {
border-width: 1px 1px 1px 1px;
}
.cp_style_350964 #cp_image-3-350964 .cp-target {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_image-3-350964 .cp-target~.cp-field-shadow {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_image-3-350964 .cp-target>.cp-close-link {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_image-3-350964 .cp-target>.cp-close-image {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_image-3-350964 .cp-target {}
.cp_style_350964 #cp_image-3-350964 .cp-target~.cp-field-shadow {}
.cp_style_350964 #cp_image-3-350964 .cp-rotate-wrap {
transform: rotate(0.00deg);
}
.cp_style_350964 #cp_image-3-350964 .cp-target:hover {}
.cp_style_350964 #cp_image-3-350964 .cp-target:hover~.cp-field-shadow {}
.cp_style_350964 #cp_image-3-350964 {
left: 331.5px;
top: 40.5px;
z-index: 11;
}
@media (max-width: 767px) {
.cp_style_350964 #cp_image-3-350964 .cp-target {
width: 97px;
height: 22px;
}
.cp_style_350964 #cp_image-3-350964 .cp-target:hover {}
.cp_style_350964 #cp_image-3-350964 .cp-target {
border-style: none;
}
.cp_style_350964 #cp_image-3-350964 .cp-target~.cp-field-shadow {
border-style: none;
}
.cp_style_350964 #cp_image-3-350964 .cp-target {
border-color: #757575;
}
.cp_style_350964 #cp_image-3-350964 .cp-target~.cp-field-shadow {
border-color: #757575;
}
.cp_style_350964 #cp_image-3-350964 .cp-target {
border-width: 1px 1px 1px 1px;
}
.cp_style_350964 #cp_image-3-350964 .cp-target~.cp-field-shadow {
border-width: 1px 1px 1px 1px;
}
.cp_style_350964 #cp_image-3-350964 .cp-target {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_image-3-350964 .cp-target~.cp-field-shadow {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_image-3-350964 .cp-target>.cp-close-link {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_image-3-350964 .cp-target>.cp-close-image {
border-radius: 0px 0px 0px 0px;
}
.cp_style_350964 #cp_image-3-350964 .cp-target {}
.cp_style_350964 #cp_image-3-350964 .cp-target~.cp-field-shadow {}
.cp_style_350964 #cp_image-3-350964 .cp-rotate-wrap {
transform: rotate(0.00deg);
}
.cp_style_350964 #cp_image-3-350964 .cp-target:hover {}
.cp_style_350964 #cp_image-3-350964 .cp-target:hover~.cp-field-shadow {}
.cp_style_350964 #cp_image-3-350964 {
left: 177px;
top: 22px;
z-index: 11;
}
}
@media (max-width: 767px) {
.cp_style_350964 .cp-invisible-on-mobile {
display: none !important;
}
}
</style>
<div class="cp-popup-content cpro-active-step cp-modal_popup cp-panel-1" data-entry-animation="cp-fadeIn" data-overlay-click="1" data-title="Excel Hacks You Never Knew" data-module-type="modal_popup" data-step="1" data-width="600"
data-mobile-width="320" data-height="400" data-mobile-height="280" data-mobile-break-pt="767" data-mobile-responsive="yes">
<div class="cpro-form-container">
<div id="cp_image-2-350964" class="cp-field-html-data cp-invisible-on-mobile cp-none cp-image-ratio" data-type="cp_image" data-action="none" data-step="1">
<div class="cp-rotate-wrap">
<div class="cp-image-main"><img width="285" height="401" data-cp-src="https://www.exceldemy.com/wp-content/uploads/2023/03/excel.jpg" class="cp-img-lazy cp-target cp-field-element cp-image" name="cp_image-2" alt="" src="">
<div class="cp-field-shadow"></div>
</div>
</div>
</div>
<div id="cp_close_image-2-350964" class="cp-field-html-data cp-none cp-image-ratio cp-close-field cp-close-image-wrap" data-type="cp_close_image" data-field-title="Close Image" data-action="close">
<div class="cp-rotate-wrap">
<div class="cp-image-main"><img width="45" height="45" data-cp-src="https://www.exceldemy.com/wp-content/plugins/convertpro/assets/admin/img/close2.png" class="cp-target cp-field-element cp-close-image cp-img-lazy" alt=""
name="cp_close_image-2" value="" src="">
<div class="cp-field-shadow"></div>
</div>
</div>
</div>
<div id="cp_heading-2-350964" class="cp-field-html-data cp-none cp_has_editor" data-type="cp_heading">
<div class="cp-rotate-wrap">
<div class="cp-target cp-field-element cp-heading tinymce" name="cp_heading-2">
<p>5 Excel Tips<br>You Never Knew</p>
</div>
</div>
</div>
<div id="cp_paragraph-2-350964" class="cp-field-html-data cp-none cp_has_editor" data-type="cp_paragraph" data-field-title="Paragraph">
<div class="cp-rotate-wrap">
<div class="cp-target cp-field-element cp-paragraph tinymce" name="{{name}}">
<p>Genius tips to help you <strong>unlock</strong> Excel's hidden features</p>
</div>
</div>
</div>
<div id="cp_paragraph-3-350964" class="cp-field-html-data cp-none cp_has_editor" data-type="cp_paragraph" data-field-title="Paragraph">
<div class="cp-rotate-wrap">
<div class="cp-target cp-field-element cp-paragraph tinymce" name="{{name}}">
<p><strong>FREE EMAIL BONUS</strong></p>
</div>
</div>
</div>
<div id="cp_email-3-350964" class="cp-field-html-data cp-none" data-type="cp_email">
<input type="email" class="cp-target cp-field-element cp-form-input-field cp-form-field cp-email cp-form-field cp-email-field" aria-label="Email Address" placeholder="Email Address" name="param[email]" value="" required="required"
data-email-error-msg="{{email-error}}" autocomplete="on">
</div>
<div id="cp_text-3-350964" class="cp-field-html-data cp-none" data-type="cp_text" data-field-title="Text">
<input type="text" class="cp-target cp-field-element cp-text cp-form-field cp-form-input-field cp-text-field" aria-label="First Name" placeholder="First Name" name="param[textfield_2832]" value="" access_cp_pro="" autocomplete="on">
</div>
<div id="cp_button-3-350964" class="cp-field-html-data cp-none" data-type="cp_button" data-action="submit_n_close" data-step="1">
<div class="cp-rotate-wrap"><button type="submit" class=" cp-target cp-field-element cp-button cp-button-field" data-success-message="SUCCESS! Watch your inbox for your free guide." data-get-param="false">YES, I WANT THIS</button>
<div class="cp-btn-tooltip"></div>
</div>
</div>
<div id="cp_image-3-350964" class="cp-field-html-data cp-invisible-on-mobile cp-none cp-image-ratio" data-type="cp_image" data-action="none" data-step="1">
<div class="cp-rotate-wrap">
<div class="cp-image-main"><img width="181" height="41" data-cp-src="https://www.exceldemy.com/wp-content/uploads/2018/05/exceldemy-logo-diamond.png" class="cp-img-lazy cp-target cp-field-element cp-image" name="cp_image-3" alt="" src="">
<div class="cp-field-shadow"></div>
</div>
</div>
</div>
</div>
</div>
<input type="hidden" name="param[date]" value="Apr 4, 2023">
<input type="text" class="cpro-hp-field" name="cpro_hp_field_350964" value="">
<input type="hidden" name="action" value="cp_v2_add_subscriber">
<input type="hidden" name="style_id" value="350964">
</form>GET https://www.exceldemy.com/
<form role="search" method="get" class="search-form" action="https://www.exceldemy.com/">
<input type="text" name="s" placeholder="Search" data-posttype="post">
<input type="hidden" name="post_type" value="post"> <button type="submit" class="btnsearch hideonmobile" aria-label="Search"><i class="rhicon rhi-search"></i></button>
</form>Text Content
Submit Excel Problem
* Home
* About Us
* Blog
* Excel Basics
* Excel Functions
* Excel Formulas
* Macros & Excel VBA
* Advanced Excel
* Excel Charts
* Data Analysis with Excel
* Excel Pivot Table
* Excel Power Query
* Excel Solver
* Excel for Finance
* Excel Templates
* Excel Pivot Table
* Excel Books
* Learn VBA
* Excel Practice
* Advanced Excel Exercises
* Calculation with Excel Formulas
* Excel Pivot Table Exercises
* Excel Training & Courses
* Interview Questions with Excel Topics
* MCQ Questions on MS Excel
* Practice Test & Quiz
* Practice with VBA
* Use of Excel Functions
Home » Excel Functions » How to Use ADDRESS Function in Excel (7 Suitable
Examples)
Excel Functions
HOW TO USE ADDRESS FUNCTION IN EXCEL (7 SUITABLE EXAMPLES)
Masum Mahdy Jan 5, 2023 0
The ADDRESS function in MS Excel is under the Lookup and Reference functions
category. We use the ADDRESS function to get the address of a cell (e.g. A45) in
an Excel worksheet in text form given specified the corresponding row and column
numbers. The ADDRESS function can return the cell address in Absolute, Mixed, or
Relative reference format (e.g. $A$45, A$45, $A45, A45, etc.) with corresponding
input. The address can also be used as the cell reference inside another
formula.
The following picture is an overview of the uses of the ADDRESS function.
MY LATEST VIDEO
Necessary-Excel-Skills-to-Get-Hired
0 seconds of 1 minute, 30 secondsVolume 0%
Press shift question mark to access a list of keyboard shortcuts
Keyboard ShortcutsEnabledDisabled
Play/PauseSPACE
Increase Volume↑
Decrease Volume↓
Seek Forward→
Seek Backward←
Captions On/Offc
Fullscreen/Exit Fullscreenf
Mute/Unmutem
Seek %0-9
Live
00:25
01:05
01:30
In this article, we will learn how we can use the ADDRESS function effectively
in Excel with suitable examples and proper illustrations.
--------------------------------------------------------------------------------
Table of Contents hide
Download Practice Workbook
Introduction to the ADDRESS Function in Excel
7 Examples of Using Excel ADDRESS Function in Different Cases
Example 1: Basic Use of ADDRESS Function in Excel
Example 2: Convert Column Number to Letter with Excel ADDRESS Function
Example 3: Addresses of the First and the Last Cells in a Range
Example 4: Get Cell Content Using the ADDRESS Function
Example 5: Address of Cell with the Lowest or the Highest Value
Example 6: Get Address of a Named Range
Example 7: Compare Two Columns and Get the Address of the Match
💡 Things to Keep in Mind
Conclusion
Related Articles
DOWNLOAD PRACTICE WORKBOOK
Click on the following button and download the sample workbook to practice along
with it.
Uses of ADDRESS Function.xlsx
--------------------------------------------------------------------------------
INTRODUCTION TO THE ADDRESS FUNCTION IN EXCEL
Function Objective:
The ADDRESS function is used to create a cell reference as text, given specified
row and column numbers.
Available in:
Excel 2007 to Excel 2021 versions & Excel 365.
Syntax:
=ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
Arguments:
Argument Required/Optional Explanation row_num Required This refers to the row
number in the cell reference. column_num Required This refers to the column
number in the cell reference. abs_num Optional This specifies the type of cell
reference to return.
* 1 or omitted– Absolute reference
* 2– Absolute row, relative column
* 3– Relative row, absolute column
* 4– Relative reference
a1
Optional This is a logical value that specifies the A1 or R1C1 reference style.
* 1 or TRUE or omitted– A1 reference style. Example: B5.
* 0 or FALSE– R1C1 reference style. Example: R5C[2].
sheet_text
Optional This indicates the sheet address of the reference. If this argument is
omitted, it refers that the cell being on the current sheet. Example:
‘Sheet1’R5C[2].
Use of Required and Optional Arguments:
Formula Description Output =ADDRESS(1,1,1,0,”[Book1]Sheet1″) Absolute reference
to another worksheet in another workbook in R1C1 style ‘[Book1]Sheet1’!R1C1
=ADDRESS(1,1,2,0,”[Book1]Sheet1″) Absolute row; relative column to another
worksheet in another workbook in R1C1 style ‘[Book1]Sheet1’!R1C[1]
=ADDRESS(1,1,4,0,”[Book1]Sheet1″) Relative reference to another worksheet in
another workbook in R1C1 style ‘Book1]Sheet1’!R[1]C[1]
=ADDRESS(1,1,1,1,”[Book1]Sheet1″) Absolute reference to another worksheet in
another workbook in A1 style ‘[Book1]Sheet1’!$A$1
=ADDRESS(1,1,2,1,”[Book1]Sheet1″) Absolute row; relative column to another
worksheet in another workbook in A1 style ‘[Book1]Sheet1’!A$1
=ADDRESS(1,1,4,1,”[Book1]Sheet1″) Relative reference to another worksheet in
another workbook in A1 style ‘[Book1]Sheet1’!A1
In the upcoming sections, we will see several examples of how we can use this
Excel function for different purposes.
--------------------------------------------------------------------------------
7 EXAMPLES OF USING EXCEL ADDRESS FUNCTION IN DIFFERENT CASES
To explore the usages of the ADDRESS function, keep going through the following
examples. Before we start, let’s see the following datasets that we are going to
use in our demonstration.
--------------------------------------------------------------------------------
EXAMPLE 1: BASIC USE OF ADDRESS FUNCTION IN EXCEL
In the first example, we will learn the basic use of the ADDRESS function.
Simple Cell Address When Only the Row and Column Numbers are Given:
In such cases, the ADDRESS function returns the cell address in A1 reference
style (column letter together with the row number), in Absolute Cell Reference
by default, and considers the cell in the current worksheet.
📌 Steps
* First of all, specify the row and column number in Cell B5 and C5 and enter
the following formula in Cell D5 to get the corresponding cell address:
=ADDRESS(B5,C5)
* After pressing the ENTER key, the function returns the cell address in the
format as stated above. The address is $T$12.
Cell Address with Reference Type, Style, and Sheet Location Given:
Let’s see the same example.
Full Formula:
=ADDRESS(B5,C5,4,0,B8)
📌 Steps
* Double-click on Cell D5 > Type ADDRESS(B5,C5 > Put a comma and then a space
after C5.
See what happens. 👇
So, if you type 1, you will get the cell address in the absolute reference, if
2,3 or 4 is typed, then you will get absolute row/relative column, relative
row/absolute column, and relative reference respectively.
* Type 4 after the comma, type another comma, and see Excel shows the following
options. 👇
If you type 0 (zero), you will get the cell address in R1C1 style. If you type
1, you will get the cell address in A1 style.
* Type 0 after the comma. Type another comma, and type your sheet name in
double quotes like “Example 1”. If you have a list of sheet names, click on
the cell that contains the specific sheet name.
* Hit ENTER.
The following picture shows the cell address. Its ‘Example 1’!R[12]C[20].
The ADDRESS function returns the cell address in two reference styles. A1 and
R1C1.
Read More: How to Lookup Value from Another Sheet in Excel (3 Easy Methods)
--------------------------------------------------------------------------------
EXAMPLE 2: CONVERT COLUMN NUMBER TO LETTER WITH EXCEL ADDRESS FUNCTION
We can convert Column Number to Column Letter, and Column Letter to Number using
the SUBSTITUTE function with the ADDRESS function. To do that, follow the steps
below.
📌 Steps
* Enter the formula below in Cell C5.
=SUBSTITUTE(ADDRESS(1,B5,4),"1","")
* Press ENTER and drag the Fill handle icon all the way.
The following picture shows the Column Letters generated from certain Column
Numbers.
🔎 Explanation
* ADDRESS(1,B5,4)
The ADDRESS function returns the address in relative reference style.
Output: “J1”.
* SUBSTITUTE(ADDRESS(1,B5,4),”1″,””)
The SUBSTITUTE function substitute 1 with an empty string “”.
Output: “J”.
In the SUBSTITUTE function, we can keep substituting “1” with “” as 1 is
hardcoded in the function.
Read More: How to Lookup Text in Excel (7 Suitable Methods)
--------------------------------------------------------------------------------
EXAMPLE 3: ADDRESSES OF THE FIRST AND THE LAST CELLS IN A RANGE
Excel ADDRESS function can return the addresses of the first and the last cells
in a range of data when combined with other Excel functions like MIN, ROW, MAX,
and COLUMN. You wonder, how is that? Let’s see then.
📌 Steps
* To find the First Cell’s address, enter the following formula in Cell F5:
=ADDRESS(MIN(ROW(B5:D12)),MIN(COLUMN(B5:D12)))
* Press ENTER.
* Enter the following formula for the last cell’s address:
=ADDRESS(MAX(ROW(B8:D15)),MAX(COLUMN(B8:D15)))
* Press ENTER.
Look at the following screenshot.
🔎 How Does the Formula Work?
* COLUMN(B5:D12)
Here, the COLUMN function returns the following array.
Output: {2,3,4}.
* MIN(COLUMN(B5:D12))
The MIN function returns the smallest number of the array {2,3,4}.
Output: {2}.
* ROW(B5:D12)
The ROW function returns an array of row-number.
Output: {5;6;7;8;9;10;11;12}.
* MIN(ROW(B5:D12))
Again, the MIN function returns the smallest number in the above array.
Output: {5}.
So, the formula ADDRESS(MIN(ROW(B5:D12)),MIN(COLUMN(B5:D12))) now becomes
ADDRESS(5,2)
* ADDRESS(5,2)
Finally, this returns the address of the first cell in the data range.
Output: “$B$5”.
The formula to find the address of the last cell works exactly the same way as
the above formula does. So, we haven’t discussed it separately.
Read More: 7 Types of Lookup You Can Use in Excel
--------------------------------------------------------------------------------
EXAMPLE 4: GET CELL CONTENT USING THE ADDRESS FUNCTION
In this example, we will see an interesting use of the ADDRESS function. When we
combine the ADDRESS and INDIRECT functions, we can get the cell content given
the row and column number. Let’s see then.
📌 Steps
* Let’s specify the row and column number first.
* Type the following formula in Cell F7:
=INDIRECT(ADDRESS(F5,G5))
* Press ENTER.
🔎 Explanation:
* ADDRESS(F5,G5)
The ADDRESS function returns the cell address given specified the row and
column number in Cell F5 and Cell G5.
Output: “$B$5”.
* INDIRECT(“$B$5”)
The INDIRECT function returns the cell content in the specified cell
reference, here in Cell B5.
Output: “S201212001”.
Read More: How to Use LOOKUP Function in Excel (4 Suitable Examples)
--------------------------------------------------------------------------------
EXAMPLE 5: ADDRESS OF CELL WITH THE LOWEST OR THE HIGHEST VALUE
In this example, we will see how to determine the address of the cell having the
lowest or the highest value in it.
📌 Steps
* Type the following formulas in Cell F5 and Cell F7.
For the address of the Lowest Value:
=ADDRESS(MATCH(MIN(D5:D12),D5:D12,0)+4, COLUMN(D5))
For the address of the Highest Value:
=ADDRESS(MATCH(MAX(D5:D12),D5:D12,0)+4, COLUMN(D5))
* Then press ENTER.
The following screenshot shows the address of the lowest and the highest
values.
🔎 How Do the Formulas Work?
* MIN(D5:D12)
The MIN function returns the smallest value in the range D5:D12.
Output: 11476.
* MATCH(11476,D5:D12,0)+4
The MATCH function finds an exact match for the output “11476” (as specified
by the third argument 0) and returns the relative position.
As we have placed the dataset in such a way that the first data occurs in the
5th row instead of the 1st row, we have added 4 in the formula to make up for
this.
Output: 2+4.
* COLUMN(D5)
The COLUMN function returns the column number of the specified cell reference
in its argument.
Output: {4}.
* ADDRESS(6,{4})
Finally, the ADDRESS function returns the cell address with respect to the
specified row and column numbers returned by the other functions, MATCH, and
COLUMN.
Output: {“$D$6”}.
Read More: How to Lookup with Multiple Criteria in Excel (Both AND or OR Type)
--------------------------------------------------------------------------------
EXAMPLE 6: GET ADDRESS OF A NAMED RANGE
To demonstrate this example, let’s first create a named range, “Data” just like
the following screenshot. To know how to create a Named Range, click here.
Now, if we want to get the full address of the named range “Data”, we need to
follow the steps below.
📌 Steps
* First of all, type the following formula in Cell F5:
=ADDRESS(@ROW(Data),@COLUMN(Data),4)&":"&ADDRESS(@ROW(Data)+ROWS(Data)-1,@COLUMN(Data)+COLUMNS(Data)-1,4)
* Press ENTER.
The following picture shows the address of the named range “Data”.
Note:
* In Excel 2021 and Excel 365, we have to use the Implicit Intersection
Operator (@) before the ROW and the COLUMN function in this formula so that
the formula doesn’t behave like an array formula and returns a single output.
* If you use Excel 2019 or an earlier version of Excel, just wipe out the @
sign from the formula and press ENTER.
🔎 How Does the Formula Work?
* @ROW(Data) and @COLUMN(Data)
In Excel 365, ROW(Data) would return {5;6;7;8;9;10;11;12} and COLUMN(Data)
would return {2,3,4}.
As we need only the first number in the array, we have added the implicit
intersection operator and the output will be the following.
Output: 5 and 2.
* ADDRESS(5,2,4)
The ADDRESS function returns the cell address in relative reference style.
Output: “B5”.
* ROWS(Data) and COLUMNS(Data)
These functions return the number of rows and columns in the Named Range
“Data”.
Output: 8 and 3.
* ADDRESS(@ROW(Data),@COLUMN(Data),4)
This part of the formula returns the address of the first cell of the range.
Output: “B5”.
* ADDRESS(@ROW(Data)+ROWS(Data)-1,@COLUMN(Data)+COLUMNS(Data)-1,4)
This part of the formula returns the address of the last cell of the range.
Output: “D12”.
* “B5″&”:”&”D12″
Finally, the ampersands (&) concatenate the two outputs with the colon and
return the final output.
Output: “B5:D12”.
--------------------------------------------------------------------------------
EXAMPLE 7: COMPARE TWO COLUMNS AND GET THE ADDRESS OF THE MATCH
We can also use the ADDRESS function to get the address of the matched values.
To do that, we have to combine IF, ISERROR, and MATCH functions with the ADDRESS
function. We will use the sample dataset-3 where there are some product data of
two shops. We have to find the matches and their cell addresses. Let’s see the
following steps.
📌 Steps
* First, type the following formula in Cell E5 and press ENTER.
=IF(ISERROR(MATCH(B5,$C$5:$C$12,0)),"Unique",ADDRESS(MATCH(B5,$C$5:$C$12,0),2))
* Then pull the Fill handle icon all the way.
🔎 How Does the Formula Work?
* MATCH(B5, $C$5:$C$12,0)
The MATCH function finds the match in the range C5:C12 for the content in
Cell B5 and returns the relative position of the exact match in C5:C12.
Output: 3.
* ADDRESS(3,2)
The ADDRESS function returns the cell address of the cell where the 3rd row
and the 2nd column intersect. We can put the column number as 2 as it is
hardcoded in the formula.
Output: “$B$3”.
* IF(ISERROR(MATCH(B5, $C$5:$C$12,0)),”Unique”, MATCH(B5, $C$5:$C$12,0),2)
If the MATCH function returns #N/A, then it is tested by the ISERROR
function, which returns TRUE or FALSE. The IF function returns “Unique” if
the statement is TRUE and if FALSE, returns the Cell Address.
Output: $B$3, Unique, Unique, Unique, $B$8, $B$6, $B$7, Unique.
Read More: How to Lookup Multiple Values in Excel (10 Ways)
--------------------------------------------------------------------------------
💡 THINGS TO KEEP IN MIND
* Please be careful and write valid arguments in the ADDRESS function.
* Invalid arguments like row or column number less than 1 or greater than the
number facilitated by Excel, any non-numeric input for row_num, column_num,
or [abs_num] arguments will return #VALUE! error.
* [a1] logical input should be one of the recognized inputs provided by Excel.
--------------------------------------------------------------------------------
CONCLUSION
So, we have discussed 7 uses of the Excel ADDRESS function. If you have any
confusion or question, please feel free to ask us in the comment box. Also, let
us know if you find the article useful. Please visit ExcelDemy.com and read more
articles based on various Excel topics. Happy reading!
--------------------------------------------------------------------------------
RELATED ARTICLES
* Advanced Excel Lookup Functions (9 Examples)
* How to Lookup a Table in Excel (8 Methods)
* Excel LOOKUP vs VLOOKUP: With 3 Examples
SaveSavedRemoved 0
Tags: ADDRESS FunctionCOLUMN FunctionCOLUMNS FunctionExcel LOOKUP FunctionIF
FunctionINDIRECT FunctionISERROR FunctionMATCH FunctionMAX FunctionMIN Function
ExcelROW FunctionROWS FunctionSUBSTITUTE Function
MASUM MAHDY
Hi there! I am Mahdy, a graduate of Naval Architecture from BUET, currently
working as an Excel & VBA Content Developer in ExcelDemy. You are gonna find my
published articles on MS Excel and other topics of my interest here in
ExcelDemy's blog. You are most welcome to my profile!
Related Articles
Added to wishlistRemoved from wishlist 0
HOW TO USE EXCEL DMAX FUNCTION (2 EASY EXAMPLES)
Added to wishlistRemoved from wishlist 0
HOW TO USE NPER FUNCTION IN EXCEL (3 RELEVANT EXAMPLES)
Added to wishlistRemoved from wishlist 0
HOW TO USE DPRODUCT FUNCTION IN EXCEL (6 PRACTICAL EXAMPLES)
Added to wishlistRemoved from wishlist 0
HOW TO USE NOMINAL FUNCTION IN EXCEL
We will be happy to hear your thoughts
LEAVE A REPLY CANCEL REPLY
Δ
EXCLUSIVE EXCEL TUTORIALS
Make a Pie Chart in Excel (5 Examples)
--------------------------------------------------------------------------------
VLOOKUP from Another Sheet in Excel
--------------------------------------------------------------------------------
Excel Advanced Filter (5 Applications)
--------------------------------------------------------------------------------
Make a Gantt Chart in Excel
--------------------------------------------------------------------------------
INDEX MATCH vs VLOOKUP Function
--------------------------------------------------------------------------------
Find External Links in Excel
--------------------------------------------------------------------------------
Goal Seek Analysis in Excel
--------------------------------------------------------------------------------
Recover Corrupted Excel File
--------------------------------------------------------------------------------
SUMIFS to SUM Values in Date Range in Excel
--------------------------------------------------------------------------------
Formula for Number of Days Between Two Dates
About ExcelDemy.com
ExcelDemy is a place where you can learn Excel, and get solutions to your Excel
& Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips,
how to guide, provide online training, and also provide Excel solutions to your
business problems.
Contact | Privacy Policy | TOS
Affiliate Disclosure:
ExcelDemy.com is a participant in the Amazon Services LLC Associates Program, an
affiliate advertising program. I earn a small commission if you buy any products
using my affiliate links to Amazon.
Follow Us
Join ExcelDemy Forum
Copyright © 2013-2022 ExcelDemy.com | All rights reserved.
5 Excel Tips
You Never Knew
Genius tips to help you unlock Excel's hidden features
FREE EMAIL BONUS
YES, I WANT THIS
Submit Excel Problem
* Submit Excel Problem
* Home
* About Us
* Blog
* back
* Excel Basics
* Excel Functions
* Excel Formulas
* Macros & Excel VBA
* Advanced Excel
* Excel Charts
* Data Analysis with Excel
* Excel Pivot Table
* Excel Power Query
* Excel Solver
* Excel for Finance
* Excel Templates
* Excel Pivot Table
* Excel Books
* Learn VBA
* Excel Practice
* back
* Advanced Excel Exercises
* Calculation with Excel Formulas
* Excel Pivot Table Exercises
* Excel Training & Courses
* Interview Questions with Excel Topics
* MCQ Questions on MS Excel
* Practice Test & Quiz
* Practice with VBA
* Use of Excel Functions
*
Update Privacy Preferences
An Elite CafeMedia Tech Publisher