{"id":58,"date":"2026-02-28T06:31:23","date_gmt":"2026-02-28T06:31:23","guid":{"rendered":"https:\/\/gigz.pk\/googlesheets\/?post_type=lesson&#038;p=58"},"modified":"2026-03-28T01:02:11","modified_gmt":"2026-03-28T01:02:11","slug":"xlookup-in-google-sheets","status":"publish","type":"lesson","link":"https:\/\/gigz.pk\/googlesheets\/lesson\/xlookup-in-google-sheets\/","title":{"rendered":"\u00a0XLOOKUP in Google Sheets"},"content":{"rendered":"\n<p>The <strong>XLOOKUP<\/strong> function in <strong>Google Sheets<\/strong> is a modern and flexible lookup function that simplifies searching for data in both vertical and horizontal ranges. Unlike VLOOKUP or HLOOKUP, XLOOKUP can search in any direction and handle missing values more efficiently.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\"><strong>1. What is XLOOKUP?<\/strong><\/h1>\n\n\n\n<p>XLOOKUP searches for a specific value in a range and returns a corresponding value from another range.<\/p>\n\n\n\n<p>It combines the functionality of VLOOKUP, HLOOKUP, and INDEX-MATCH into a single, easy-to-use function.<\/p>\n\n\n\n<p><strong>Syntax:<\/strong><br><code>=XLOOKUP(search_key, lookup_range, return_range, [if_not_found], [match_mode], [search_mode])<\/code><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>search_key<\/strong> \u2014 The value to search for<\/li>\n\n\n\n<li><strong>lookup_range<\/strong> \u2014 The range to search in<\/li>\n\n\n\n<li><strong>return_range<\/strong> \u2014 The range from which to return a value<\/li>\n\n\n\n<li><strong>if_not_found<\/strong> \u2014 (Optional) Value to return if not found<\/li>\n\n\n\n<li><strong>match_mode<\/strong> \u2014 (Optional) 0 for exact match (default), -1 for exact or next smaller, 1 for exact or next larger<\/li>\n\n\n\n<li><strong>search_mode<\/strong> \u2014 (Optional) 1 for search first to last (default), -1 for search last to first<\/li>\n<\/ul>\n\n\n\n<h1 class=\"wp-block-heading\"><strong>2. Simple Example<\/strong><\/h1>\n\n\n\n<p><code>=XLOOKUP(101, A2:A10, B2:B10, \"Not Found\")<\/code><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Searches for 101 in A2:A10<\/li>\n\n\n\n<li>Returns the corresponding value from B2:B10<\/li>\n\n\n\n<li>If 101 is not found, it returns \u201cNot Found\u201d<\/li>\n<\/ul>\n\n\n\n<h1 class=\"wp-block-heading\"><strong>3. Advantages of XLOOKUP<\/strong><\/h1>\n\n\n\n<p>Searches both vertically and horizontally<br>No need to specify column index like VLOOKUP<br>Handles missing values gracefully<br>Supports approximate matches and reverse searches<br>Simpler syntax than combining INDEX and MATCH<\/p>\n\n\n\n<h1 class=\"wp-block-heading\"><strong>4. Use Cases<\/strong><\/h1>\n\n\n\n<p>Retrieve employee names based on ID<br>Find product prices using product codes<br>Match sales records to customer IDs<br>Handle dynamic datasets with flexible lookup requirements<\/p>\n\n\n\n<h1 class=\"wp-block-heading\"><strong>5. Tips for Using XLOOKUP<\/strong><\/h1>\n\n\n\n<p>Always use the <strong>if_not_found<\/strong> argument to avoid errors<br>Ensure lookup and return ranges are the same size<br>Use match_mode for approximate matches when needed<br>Combine with other functions like IF or ARRAYFORMULA for advanced solutions<\/p>\n\n\n\n<h1 class=\"wp-block-heading\"><strong>Conclusion<\/strong><\/h1>\n\n\n\n<p>XLOOKUP in Google Sheets is a powerful, flexible lookup function that replaces traditional VLOOKUP, HLOOKUP, and INDEX-MATCH in most scenarios.<\/p>\n\n\n\n<p>Mastering XLOOKUP allows you to perform faster, more accurate lookups, handle missing data, and simplify complex spreadsheet tasks.<\/p>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1774659684851\"><strong class=\"schema-faq-question\"><\/strong> <p class=\"schema-faq-answer\"><\/p> <\/div> <\/div>\n\n\n<div class=\"yoast-breadcrumbs\"><span><span><a href=\"https:\/\/gigz.pk\/googlesheets\/\">Home<\/a><\/span> \u00bb <span class=\"breadcrumb_last\" aria-current=\"page\">GOOGLE SHEETS FOR BUSINESS (GSB) > Advanced Functions > XLOOKUP in Google Sheets<\/span><\/span><\/div>","protected":false},"menu_order":21,"template":"","class_list":["post-58","lesson","type-lesson","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u00a0XLOOKUP in Google Sheets - Collaborate. Analyze. Automate.<\/title>\n<meta name=\"description\" content=\"Learn XLOOKUP in Google Sheets with examples. Discover how to replace VLOOKUP and perform fast, flexible data lookups easily.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/gigz.pk\/googlesheets\/lesson\/xlookup-in-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00a0XLOOKUP in Google Sheets - Collaborate. Analyze. Automate.\" \/>\n<meta property=\"og:description\" content=\"Learn XLOOKUP in Google Sheets with examples. Discover how to replace VLOOKUP and perform fast, flexible data lookups easily.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/gigz.pk\/googlesheets\/lesson\/xlookup-in-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Collaborate. Analyze. Automate.\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-28T01:02:11+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\\\/\\\/gigz.pk\\\/googlesheets\\\/lesson\\\/xlookup-in-google-sheets\\\/\",\"url\":\"https:\\\/\\\/gigz.pk\\\/googlesheets\\\/lesson\\\/xlookup-in-google-sheets\\\/\",\"name\":\"\u00a0XLOOKUP in Google Sheets - Collaborate. Analyze. Automate.\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/gigz.pk\\\/googlesheets\\\/#website\"},\"datePublished\":\"2026-02-28T06:31:23+00:00\",\"dateModified\":\"2026-03-28T01:02:11+00:00\",\"description\":\"Learn XLOOKUP in Google Sheets with examples. Discover how to replace VLOOKUP and perform fast, flexible data lookups easily.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/gigz.pk\\\/googlesheets\\\/lesson\\\/xlookup-in-google-sheets\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/gigz.pk\\\/googlesheets\\\/lesson\\\/xlookup-in-google-sheets\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/gigz.pk\\\/googlesheets\\\/lesson\\\/xlookup-in-google-sheets\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/gigz.pk\\\/googlesheets\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"GOOGLE SHEETS FOR BUSINESS (GSB) > Advanced Functions > XLOOKUP in Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/gigz.pk\\\/googlesheets\\\/#website\",\"url\":\"https:\\\/\\\/gigz.pk\\\/googlesheets\\\/\",\"name\":\"Collaborate. Analyze. Automate.\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/gigz.pk\\\/googlesheets\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00a0XLOOKUP in Google Sheets - Collaborate. Analyze. Automate.","description":"Learn XLOOKUP in Google Sheets with examples. Discover how to replace VLOOKUP and perform fast, flexible data lookups easily.","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:\/\/gigz.pk\/googlesheets\/lesson\/xlookup-in-google-sheets\/","og_locale":"en_US","og_type":"article","og_title":"\u00a0XLOOKUP in Google Sheets - Collaborate. Analyze. Automate.","og_description":"Learn XLOOKUP in Google Sheets with examples. Discover how to replace VLOOKUP and perform fast, flexible data lookups easily.","og_url":"https:\/\/gigz.pk\/googlesheets\/lesson\/xlookup-in-google-sheets\/","og_site_name":"Collaborate. Analyze. Automate.","article_modified_time":"2026-03-28T01:02:11+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["WebPage","FAQPage"],"@id":"https:\/\/gigz.pk\/googlesheets\/lesson\/xlookup-in-google-sheets\/","url":"https:\/\/gigz.pk\/googlesheets\/lesson\/xlookup-in-google-sheets\/","name":"\u00a0XLOOKUP in Google Sheets - Collaborate. Analyze. Automate.","isPartOf":{"@id":"https:\/\/gigz.pk\/googlesheets\/#website"},"datePublished":"2026-02-28T06:31:23+00:00","dateModified":"2026-03-28T01:02:11+00:00","description":"Learn XLOOKUP in Google Sheets with examples. Discover how to replace VLOOKUP and perform fast, flexible data lookups easily.","breadcrumb":{"@id":"https:\/\/gigz.pk\/googlesheets\/lesson\/xlookup-in-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/gigz.pk\/googlesheets\/lesson\/xlookup-in-google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/gigz.pk\/googlesheets\/lesson\/xlookup-in-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/gigz.pk\/googlesheets\/"},{"@type":"ListItem","position":2,"name":"GOOGLE SHEETS FOR BUSINESS (GSB) > Advanced Functions > XLOOKUP in Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/gigz.pk\/googlesheets\/#website","url":"https:\/\/gigz.pk\/googlesheets\/","name":"Collaborate. Analyze. Automate.","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/gigz.pk\/googlesheets\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/gigz.pk\/googlesheets\/wp-json\/wp\/v2\/lesson\/58","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gigz.pk\/googlesheets\/wp-json\/wp\/v2\/lesson"}],"about":[{"href":"https:\/\/gigz.pk\/googlesheets\/wp-json\/wp\/v2\/types\/lesson"}],"wp:attachment":[{"href":"https:\/\/gigz.pk\/googlesheets\/wp-json\/wp\/v2\/media?parent=58"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}