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 DOMGET 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