# Google Sheets LOOKUP Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/lookup-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The LOOKUP function searches for a value in a range and returns a corresponding value from another range, useful for finding data. ``` LOOKUP(search_key, search_range|search_result_array, [result_range]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the LOOKUP you need in plain EnglishGenerate Formula ## Parameters **`search_key`**:\ The value that you want to search for within the specified `search_range` or `search_result_array`. **`search_range|search_result_array`**:\ The range of cells that you want to search through for the `search_key`. This can also be an array of values from which to retrieve the result. **`result_range`**:\ (Optional) The range of cells from which to return the corresponding value if the `search_key` is found in the `search_range`. If omitted, the function returns the value from the `search_range` or `search_result_array`. ## What is a LOOKUP? The *LOOKUP* function in Google Sheets is a fundamental tool used to search for a value in a one-dimensional range or array and return a corresponding value from another one-dimensional range or array. It is a simple yet effective way to retrieve data based on a specific criterion. While it may not be as versatile as newer functions like XLOOKUP, it remains a valuable function for straightforward lookup tasks. In simpler terms, LOOKUP allows you to find specific data in a row or column and retrieve related information from that row or column. ## A Practical Example Imagine you are managing a list of students and their corresponding grades stored in a Google Sheets document: ### Students Table: | StudentID | StudentName | Grade | | - | - | - | | 1 | Alice | A | | 2 | Bob | B | | 3 | Charlie | C | You want to find the grade of each student based on their StudentID. ## LOOKUP Formula To achieve this, you would use the LOOKUP function as follows: ``` =LOOKUP(B2, Students!A:A, Students!C:C) ``` In this formula: - `B2` is the cell containing the StudentID you want to look up. - `Students!A:A` is the range where the function will look for the StudentID in the Students Table. - `Students!C:C` is the range from which the function will return the corresponding Grade. ## Result of the Formula When you apply the LOOKUP formula to the Students Table, the output would look like this: | StudentID | StudentName | Grade | | - | - | - | | 1 | Alice | A | | 2 | Bob | B | | 3 | Charlie | C | If you were to add a row for a student that hasn't been included, such as StudentID 4, the result would still show the corresponding grade if it exists: | StudentID | StudentName | Grade | | - | - | - | | 1 | Alice | A | | 2 | Bob | B | | 3 | Charlie | C | | 4 | David | #N/A | In this case, if you input StudentID 4 in the lookup, the LOOKUP would return `#N/A` since there is no corresponding grade for David. ## Why Use LOOKUP? LOOKUP is beneficial because it provides a straightforward way to retrieve data without the complexity of nested functions. It is particularly useful for simple datasets where you need to find a value based on a single criterion. However, it is important to note that LOOKUP assumes the data is sorted in ascending order, which may limit its use in some scenarios. ## Key Takeaways: - **LOOKUP**: A basic function that searches for a value and returns a corresponding value from another range. - **Simplicity**: Ideal for straightforward lookup tasks with simple datasets. - **Limitations**: Assumes sorted data and may not handle errors as gracefully as newer functions. - **Common Use Cases**: Suitable for small datasets, quick lookups, and scenarios where data is organized in a single dimension. LOOKUP is a fundamental function for anyone working with data in Google Sheets, providing a simple way to enhance data retrieval tasks. Happy spreadsheeting! ## Example use case You have a sales report where Column A lists product IDs and Column B contains their prices. By using the LOOKUP formula, you can input a product ID to quickly find its price, streamlining the process of pricing inquiries and inventory management. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Freeze Panes In Google Sheets](https://betteranalyst.com/google-sheets/how-to-freeze-panes-in-google-sheets) - [How To Highlight Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-highlight-duplicates-in-google-sheets) - [How To Insert Checkbox In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-checkbox-in-google-sheets) - [How To Insert Multiple Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-multiple-rows-in-google-sheets) - [How To Lock A Row In Google Sheets](https://betteranalyst.com/google-sheets/how-to-lock-a-row-in-google-sheets) - [How To Lock Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-lock-cells-in-google-sheets) - [How To Make A Copy Of An Google Sheets Sheet](https://betteranalyst.com/google-sheets/how-to-make-a-copy-of-an-google-sheets-sheet) - [How To Make A Graph In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-graph-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.