{"id":50632,"date":"2024-09-26T23:21:52","date_gmt":"2024-09-26T21:21:52","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=50632"},"modified":"2025-06-03T22:13:11","modified_gmt":"2025-06-03T20:13:11","slug":"comment-utiliser-xlookup-dans-google-sheets-formules-et-exemples","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/google-sheets-features\/how-to-use-xlookup-in-google-sheets-formulas-and-examples\/","title":{"rendered":"Comment utiliser XLOOKUP dans Google Sheets (+ formules et exemples) ?"},"content":{"rendered":"\n[et_pb_section fb_built=”1″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_row _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

According to <\/span>Exploding Topics<\/span><\/a>, over 900 million people use Google Sheets monthly. But how many use XLOOKUP in Google Sheets<\/span><\/p>\n

This tutorial will show you how to use it to <\/span>pull data<\/span><\/a> from the same spreadsheet or two different spreadsheets.<\/span><\/p>\n

We will also discuss the best and easiest alternative to XLOOKUP.<\/span><\/p>\n

Keep reading!<\/span><\/p>[\/et_pb_text][et_pb_text admin_label=”Connections T – Automate between spreadsheets – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button-light vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” saved_tabs=”all” global_colors_info=”{}” global_module=”50460″ theme_builder_area=”post_content”]

\"\"<\/p>\n

\"39\"<\/p>\n

Automate data transfers between spreadsheets
<\/span><\/p>\n

Find out how<\/a><\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

What is XLOOKUP?<\/b><\/h2>\n

In simple terms, XLOOKUP helps you find specific information in your Google Sheets. You tell XLOOKUP what to look for (like a student’s grade) and where to look (which column in your gradebook). Then, it quickly finds the matching information and returns it to you.<\/span><\/p>\n

XLOOKUP is a more flexible alternative to older <\/span>functions<\/span><\/a> like <\/span>VLOOKUP<\/span><\/a> and <\/span>HLOOKUP<\/span><\/a>.<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

How to use XLOOKUP in Google Sheets?<\/b><\/h2>\n

Let\u2019s say you are a teacher and use a Google Sheet to track your students’ grades. We will name the spreadsheet \u201cStudents Exams.\u201d<\/span><\/p>\n

Now, the spreadsheet has two sheets:<\/span><\/p>\n