{"id":1336,"date":"2018-07-04T10:29:54","date_gmt":"2018-07-04T10:29:54","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1336"},"modified":"2024-02-05T17:24:37","modified_gmt":"2024-02-05T17:24:37","slug":"address","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/address\/","title":{"rendered":"ADDRESS function"},"content":{"rendered":"\n<p>Excel ADDRESS Function allows you to create a text representation of a cell&#8217;s address, based on specified row and column numbers. It&#8217;s like giving Excel a set of coordinates and having it return the cell&#8217;s address in text form.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Syntax<\/h2>\n\n\n\n<p><strong>ADDRESS(row_num, column_num, [abs_num], [a1], [sheet])<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Arguments<\/h2>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td><b>row_num:<\/b><\/td><td>The row number for which you want to find the cell address.<\/td><\/tr><tr><td><b>column_num:<\/b><\/td><td>The column number for which you want to find the cell address.<\/td><\/tr><tr><td><b>[abs_num]:<\/b><\/td><td>(Optional) An optional argument specifying the type of cell reference to return:<ul><li>1 or omitted: Relative cell reference (default).2: Absolute column and relative row.3: Relative column and absolute row.4: Absolute cell reference.<\/li><\/ul><\/td><\/tr><tr><td><b>[a1]:<\/b><\/td><td>(Optional) An optional argument specifying the reference style:  <ul><li>TRUE or omitted: A1 reference style (default).FALSE: R1C1 reference style. <\/li><\/ul><\/td><\/tr><tr><td><b>[sheet]:<\/b><\/td><td>(Optional) An optional argument specifying the sheet name or reference. If omitted, it refers to the current sheet.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How to use<\/h2>\n\n\n\n<p>Let&#8217;s understand how to use the ADDRESS function with some examples:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=ADDRESS(2, 3)<\/code><\/pre>\n\n\n\n<p>This formula will return the address of the cell in the 2nd row and 3rd column with the default A1 reference style. In this case, it would return &#8220;C2.&#8221;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=ADDRESS(4, 2, 2, TRUE)<\/code><\/pre>\n\n\n\n<p>Here, the function returns the address with an absolute column (column 2) and a relative row (row 4) using the A1 reference style. The result would be &#8220;$B4.&#8221;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=ADDRESS(1, 1, 4, FALSE, \"Sheet2\")<\/code><\/pre>\n\n\n\n<p>This example returns an absolute cell reference in R1C1 style for cell A1 on &#8220;Sheet2.&#8221; The result would be &#8220;Sheet2!R1C1.&#8221;<\/p>\n\n\n\n<p>These are just a few examples of how you can use the ADDRESS function to generate cell references in different ways. It can be especially useful when building dynamic formulas or creating custom cell references.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel ADDRESS Function allows you to create a text representation of a cell&#8217;s address, based on specified row and column numbers. It&#8217;s like&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>ADDRESS function<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/functions\/address\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ADDRESS function\" \/>\n<meta property=\"og:description\" content=\"Excel ADDRESS Function allows you to create a text representation of a cell&#8217;s address, based on specified row and column numbers. It&#8217;s like...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/address\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-04T10:29:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-05T17:24:37+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/address\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/address\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"ADDRESS function\",\"datePublished\":\"2018-07-04T10:29:54+00:00\",\"dateModified\":\"2024-02-05T17:24:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/address\/\"},\"wordCount\":284,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/address\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/address\/\",\"name\":\"ADDRESS function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-04T10:29:54+00:00\",\"dateModified\":\"2024-02-05T17:24:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/address\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/address\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/address\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ADDRESS function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ADDRESS function","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/functions\/address\/","og_locale":"en_US","og_type":"article","og_title":"ADDRESS function","og_description":"Excel ADDRESS Function allows you to create a text representation of a cell&#8217;s address, based on specified row and column numbers. It&#8217;s like...","og_url":"https:\/\/officetuts.net\/excel\/functions\/address\/","article_published_time":"2018-07-04T10:29:54+00:00","article_modified_time":"2024-02-05T17:24:37+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/address\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/address\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"ADDRESS function","datePublished":"2018-07-04T10:29:54+00:00","dateModified":"2024-02-05T17:24:37+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/address\/"},"wordCount":284,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/address\/","url":"https:\/\/officetuts.net\/excel\/functions\/address\/","name":"ADDRESS function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-04T10:29:54+00:00","dateModified":"2024-02-05T17:24:37+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/address\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/address\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/address\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"ADDRESS function"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1336"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1336"}],"version-history":[{"count":6,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1336\/revisions"}],"predecessor-version":[{"id":16942,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1336\/revisions\/16942"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}