Index function in excel meaning. Few sample uses of INDEX1.

Index function in excel meaning. May 5, 2025 · Lookup functions in Excel allow users to search for specific data within a dataset and return corresponding information from another column or row. This is a number that refers to subsequent values by index or position. You can use INDEX to retrieve individual values, or entire rows and columns. It is often used in combination with other functions to perform more complex calculations or data manipulations. For example: =INDEX (A1:D10, MATCH ("John", A1:A10, 0), 4) will return the value in the 4th column of the row where "John" is located in column A. 1 day ago · Najnovije vijesti iz svijeta. Functions are typed by = and the functions name. Learn how to apply the INDEX function for financial modeling purposes. INDEX formula gives us value or the reference to a value from within a table or range. Step-by-step instructions, examples, and tips for accurate and efficient results. You want to get the name of 8th item in a list write =INDEX(list, 8) Mar 21, 2022 · By using the INDEX function, you designate the cell range along with a row number and column number. XLOOKUP is a modern and flexible replacement for older functions like VLOOKUP, HLOOKUP, and LOOKUP. This function is often used with MATCH so the finding process done by the function can be practiced in a more dynamic way Below is the brief explanation about the inputs in these formulas. There are two ways to use the INDEX function: If you want to return a reference to specified cells, Click to see Reference form If you want to return the value of a specified cell or array of cells, Click to Nov 9, 2022 · The INDEX function can be set up to return all the values in row 3 for example. Here you will find 10 XLOOKUP examples + download file Guide to the INDEX MATCH Function in Excel. Mar 26, 2025 · Learn how the Excel MATCH function locate the position of a specific value within a given range or array with dynamic lookups, advanced examples, and best practices. The next arguments, value1, value2, value3, etc. The MATCH function is used to figure out where the lookup value is located in a range of cells. How to use the MATCH function in Excel to search for a specified item in a range of cells, returning the relative position of that item in the range. The INDEX function is one of the most popular tools used in Excel and is a perfect upgrade to the VLOOKUP function. Pavan Lalwani Tutorials Point India Pri What is INDEX function in Excel? INDEX function is one of Lookup and Reference functions in Microsoft Excel that returns a value or the reference to a value from within a table or range. Using the VLOOKUP Function in Excel You can easily create a function to look up information! The VLOOKUP function consists of three required arguments, in the following order: lookup value, table array, and column index number. Learn how to use the INDEX function in Excel with step-by-step examples. Aug 30, 2024 · The Excel INDEX function returns the value at a given location in a range or array. If it finds it, it returns the corresponding value from a different column in the same row. 3. It is a tool for pinpointing data in a table. Orange Purple Yellow This is just one example of the how the INDEX function can return multiple values. INDEX svake nedjelje donosi deset dobrih vijesti tjedna - priče o dobrim ljudima koji nesebično pomažu drugima, malim i velikim uspjesima, važnim sportskim podvizima, znanstvenim otkrićima i svim drugim događajima koji su nam uljepšali tjedan. Feb 12, 2023 · The Excel INDEX function returns the value at a given location in a range or array. This function allows you to discover and return items in Excel spreadsheets. Complete guide with examples + sample file The INDEX function is a powerful and versatile tool in Microsoft Excel that allows users to return a value or the reference to a value from within a particular range of cells or array. We have covered a lot of examples so that you can use the function at your work effectively. Learn how to retrieve values by their position in a table and differentiate it from VLOOKUP. Feb 9, 2023 · The INDEX Function works exactly the same in Google Sheets as in Excel: INDEX Examples in VBA You can also use the INDEX function in VBA. This function has two forms of use: Array and Reference. Read this now to use VLOOKUP effectively. It looks up the value of a cell at the intersection of a given row and column. Sep 1, 2025 · INDEX and MATCH An alternative to using the VLOOKUP function is to combine the INDEX and MATCH functions. Guide to SHEET Excel Function in Excel & its meaning. In this tutorial, we will cover the basics of what INDEX is in Excel and how it can be used to efficiently retrieve data from a table. Ne objavljujemo proizvode koje i sami ne bismo kupili ili smatramo da njihova promocija nije u skladu s profesionalnim standardima. Index Oglasi - Najbrže rastući oglasnik u Hrvatskoj. We learn how to use it to retrieve row data in different ways with examples and working templates. Apr 11, 2022 · INDEX and MATCH Function Basics To use these functions together, it's important to understand their purpose and structure. May 6, 2025 · The Excel XLOOKUP function is a powerful tool designed to look up a value in one range and return a corresponding value in another range — it supports approximate and exact matching, wildcards, regular expressions (regex), reverse searches, and lookups in vertical or horizontal ranges. Functions Excel has many premade formulas, called functions. The Index Function returns the value of an array given a specific row and column. There are two ways to use the INDEX function: If you want to return the value of a specified cell or array of cells, see Array form. worksheetfunction. Follow this step-by-step guide to improve your spreadsheet skills. Jun 5, 2021 · The CHOOSE function returns a value from a list using a given position or index. This way, you can enter the column and row parameters directly in a cell and dynamically adjust the formula. The INDEX function can also be combined with other functions in Excel, such as MATCH, to perform more complex lookups. Aug 30, 2024 · How to Use VLOOKUP in Excel: 4 Easy Steps (For Beginners) The VLOOKUP function searches for a specific value in a dataset. May 14, 2020 · Practical examples of how to use the Excel INDEX function The simplest way to use the Excel INDEX function is to reproduce the content of a specific cell. This allows you to look for data in one spreadsheet and bring it to another spreadsheet in a few seconds And that’s what makes VLOOKUP one of the most time-saving functions in Jul 10, 2024 · How to use the SORT function in Excel. This article introduces the basic concepts you need to know to be proficient with formulas in Excel. The INDEX function is often used with the MATCH function. It is typed =VLOOKUP and has the following parts: The VLOOKUP function is one of the most popular functions in Excel. MS Excel - Index FunctionWatch More Videos at: https://www. column_num (optional): The column number of the value to How to use the VLOOKUP Function in Excel : This is one of the most used and popular functions of excel that is used to lookup value from different ranges and sheets. Plain English: This formula will help quickly you locate values within an array. Here we learn how to use it, its formula, examples, and a downloadable excel template. VLOOKUP Function The VLOOKUP function is a premade function in Excel, which allows searches across columns. Mar 13, 2023 · The tutorial explains what may cause a #SPILL error in an INDEX MATCH, VLOOKUP, SUMIF and COUNTIF formulas and how you can efficiently resolve it. Jun 19, 2023 · INDEX MATCH is a powerful tool in Excel. Learn Formulas, Excel and VBA with examples. Replacing #N/A with your own value only identifies the error, but does not resolve it. Choose can handle . If you want to return a reference to specified cells, see Reference form. Prijelomne vijesti, prvi u Hrvatskoj! Najčitaniji hrvatski news portal. Our step-by-step guide makes vlookup in excel easy and efficient. With a combination of functions, you can create some advanced Excel formulas that can do some Mar 18, 2025 · Learn how to use the INDEX function in Excel to retrieve data efficiently. Excel INDEX Function (Examples + Video) When to use Excel INDEX Function Excel INDEX function can be used when you want to fetch the value from a tabular data and you have the row number and column number of the data point. The combination of the INDEX and MATCH functions is an alternative to the VLOOKUP function, which Feb 9, 2023 · The INDEX Function works exactly the same in Google Sheets as in Excel: INDEX Examples in VBA You can also use the INDEX function in VBA. What it does: THE INDEX () Function returns a value based on the array of values you select and the row and column within that array (column is optional). Najčitanije vijesti iz Hrvatske i svijeta iz minute u minutu: ekskluzive i otkrića, politika, ekonomija, crna kronika, stanje u prometu, nogomet, košarka, zabava i zvijezde. Write the lookup_value as the first argument. We can say it is an alternative way to do VLOOKUP. Introduction Understanding Excel functions is crucial for anyone working with data or spreadsheets. TV zvijezde, glumci i pjevači, sportaši, ljepotice, skandali, reality, lifestyle, tehnologija, mobiteli, aplikacije, glazba 4 days ago · Bivši šef: Tudor me pogledao, zagrlio i poderao ugovor. INDEX Function in Excel. Syntax: array : It is the range or an array. tutorialspoint. Instead of using VLOOKUP, use INDEX and MATCH. It's way better than VLOOKUP or INDEX/MATCH. The values provided to CHOOSE can be hard-coded constants or cell references. Using this combination you can lookup a value in ANY column. Feb 21, 2013 · INDEX Function in Excel - formula returns either the value or the reference to a value from a table or range. In this article, I'll show you 10 examples of using this. The INDEX Function in Excel You can use the INDEX function two different ways in Excel: Array Form and Reference Form. Regardless of your background and profession, if you regularly use Excel in your work, you can likely benefit from using the two combined functions. Enhance your data analysis skills today! Mar 6, 2024 · Discover the power of VLOOKUP in Excel. By knowing how to perform these functions, you can return items with more ease. Values can be sorted by one or more columns. ding Excel LOOKUP functions. For example, suppose you have a table listing planets in our solar system (as shown below), and you want to find the name of the 4th planet, which is Mars. 10 easy examples are discussed with proper explanation. 5 days ago · Learn how to use Index Match in Excel for advanced data lookup and analysis. This article gives you a quick VLOOKUP refresher, then links to more. But the other LOOKUP functions do the same thing, no? So what distinguishes INDEX from other functions, and how do you use it? Read on to find answers to these and a lot more questions. INDEX Function Syntax in Excel: =INDEX (reference, [row], [column]) Parameters: array: The range containing the data (e. In this section, we’ll explore HLOOKUP examples in Excel that demonstrate how to use the function for quick and efficient data retrieval. row_num: The row number of the value to retrieve. Jun 6, 2025 · The INDEX and MATCH formulas are two functions in Microsoft Excel. However, if you are working with a single column of items instead of Aug 30, 2024 · The OFFSET function returns a range of cells located a specified number of rows/columns from a cell. The Microsoft Excel INDEX function returns a value in a table based on the intersection of a row and column position within that table. How to Use the INDEX Function To use the INDEX function, you generally need three arguments. For example =SUM Once you have typed the function name you need to apply it to a range. The INDEX function in Excel is a powerful tool that allows you to retrieve the value from a specific position within an array or a range of cells. INDEX function in excel is a function with the usage objective to pull data from a cell range by telling the position of the data in the cell range. Discover how to use the INDEX function in Excel to retrieve values from a specified array based on row and optional column numbers. The syntax for index/match is =INDEX (column to return a value from, MATCH (lookup value, column to look up against, 0)) The MATCH function searches for the lookup value in the column you decide, e. Aug 30, 2024 · 1. Jun 6, 2025 · Learn what the INDEX function is, discover why it's important and explore how to use the INDEX function in Excel, including five methods with full explanations. You can either enter the coordinates directly as a number or establish a cell reference. All the examples are explained properly. Aug 5, 2025 · INDEX MATCH, a combination of the two Excel functions, INDEX() and MATCH(), is an alternative to the commonly used VLOOKUP() function. The main advantages of the function in Excel formulas. To effectively utilize the INDEX function, follow the comprehensive steps outlined below: Open Excel: Launch Microsoft Excel on your computer. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. Cell references can be used to make working with the formula a little easier. But what does INDEX actually do? In simple terms, it retrieves a value from a specific location within a range. Simplify data extraction and enhance your productivity. You can use INDEX to accomplish Learn how to use function VLOOKUP in Excel to find data in a table or range by row. It helps you locate and retrieve values from different parts of a table or an array, making data lookup operations straightforward. Learn to use the SORT function to sort any range of cells according to any row or column of your wish. The INDEX-MATCH combination is a formidable pair of functions in Excel, offering an alternative to the traditional VLOOKUP function. INDEX’s final output is a union of these rows. Jun 2, 2025 · The INDEX function in Excel is designed to return the value or reference of a cell at the intersection of a specified row and column within a given range or array. Mar 22, 2023 · Excel OFFSET function examples demonstrate the most efficient ways to use OFFSET in Excel to make dynamic ranges, sum the last N rows, create powerful Vlookup formulas, and more. Aug 9, 2023 · The INDEX function within Excel empowers you to retrieve a value from a specific location in a range based on its row and column numbers. It is particularly useful for looking up values in a table based on row and column coordinates. SORT returns a dynamic array of results. This guide has all you need to know. This page contains many easy to follow VLOOKUP examples. If you’ve used Excel even for a few days, I am sure you have heard of functions like VLOOKUP, SUMIF, COUNTIF, and so on. We’ll also give examples to help you get good at it. Few sample uses of INDEX1. Often, MATCH is combined with the INDEX function to retrieve a value at a matched position. INDEX looks up a position and returns its value. Enhance your Excel skills with the INDEX function. Sep 12, 2017 · Learn how to use both VLOOKUP and INDEX-MATCH in Excel, including multiple criteria and case-sensitive lookups, and to get the last value in a range. We use the INDEX function in Excel with the MATCH function more commonly. HLOOKUP supports approximate and exact matching, and wildcards (* ?) for finding partial matches. Learn how to use the INDEX Function in excel. Unlike lookup functions that search for values based on matching criteria, INDEX works purely by position, which makes it highly efficient and flexible. Here we learn the formula and uses of HLOOKUP function with step-wise examples and downloadable template. Aug 30, 2024 · Its primary purpose is to return a cell reference from a specified array. Feb 7, 2024 · The INDEX function in Excel is a very powerful formula within the search and reference functions. Type: application. Write the HLOOKUP function. Feb 6, 2020 · Learn all about the new Excel XLOOKUP Function. htmLecture By: Mr. The combination of the INDEX and MATCH functions is an alternative to the VLOOKUP function, which About INDEX Use the INDEX function in Excel to extract specific data from tables or arrays based on row and column references. One important function that is commonly used is the INDEX function. Jul 6, 2024 · The INDEX function in Excel is a powerful tool used to return the value of an element in a table or array, selected by the row and column number indexes. This Excel tutorial explains how to use the Excel INDEX function with syntax and examples. Jul 31, 2025 · VLOOKUP in Excel searches for a value in the first column of a specified range and retrieves a value from the same row in a designated column. Jul 9, 2025 · The Excel VLOOKUP function is used to retrieve information from a table using a lookup value. Index function returns the cell value at matching row and column index in array. Aug 8, 2025 · The INDEX function retrieves a value from a specified location within a range, using row and column offsets. This tutorial demonstrates how to use Excel INDEX with an easy to follow example and takes you step-b Guide to VBA Index Match. Jun 12, 2024 · This article explains 3 Excel formulas for Excel INDEX and MATCH with multiple criteria. Jun 5, 2025 · If you want to improve your Excel skills, you may wonder how to use Index and Match. 5 days ago · Before you can learn the technical use cases of INDEX and MATCH functions in a single Excel formula, you must learn the basics of these formulas and how to write these functions. If so, it will return all of the following values. Oct 19, 2023 · Most people never receive proper Excel training and spend years frustrated by the simplest tasks, especially tasks that involve formulas. The first argument for the CHOOSE function is index_num. "Hrvatski nogomet ima problem o kojem nitko ne govori. To perform advanced lookups, you'll need INDEX and MATCH. Najnovije vijesti iz svijeta showbiznisa. Sep 16, 2023 · How to write INDEX MATCH functions as a powerful alternative to VLOOKUP that are more efficient, flexible and robust. Aug 10, 2024 · The INDEX function in Excel is both versatile and powerful, often featured in advanced formulas. You will find a number of formula examples such as Iferror blank, If Iserror Vlookup INDEX/MATCH does the same thing as LOOKUP, but it's more powerful and versatile. It retrieves data from a specific row and column within an array. For every combination of existing values for these columns in INDEX’s parent context, INDEX is evaluated and a row is returned. Iz minute u minutu: politika, ekonomija, ratovi i sukobi u svijetu, crna kronika, Trump, Merkel, Macron, Palestina, komentari i analize. Aug 9, 2025 · The INDEX MATCH combo is a game-changer for Excel users. The Excel INDEX function returns a value that is referenced from a specific range. May 28, 2025 · The Excel INDIRECT function returns a valid cell reference from a given text string. This combination can be used as an alternative to using the VLOOKUP (and HLOOKUP) functions. Learn how to find and retrieve data with this popular function without mistakes. This is because INDEX and MATCH are incredibly flexible – you can do horizontal and vertical lookups, 2-way lookups, left lookups, case-sensitive lookups, and even lookups based on multiple criteria. Here we learn to use the Index & Match functions in Excel VBA to find particular values with examples. What is the INDEX function? INDEX is a powerful tool for making references within a financial model. The lookup values must appear in the first column of the table, and the information to retrieve is specified by column number. INDEX will first determine all partitionBy and matchBy columns that have no corresponding outer column. Aug 6, 2024 · Learn how to use the Excel INDEX function. Sep 18, 2013 · Understand how to use INDEX formula, what is its syntax, how it can help you extract and analyze any data with ease. The "H" in HLOOKUP stands for "horizontal", and lookup values must appear in the first row of the table, moving horizontally to the right. Odrekao se novca Index Sport | prije 15 minuta 3 days ago · Pri kreiranju rubrike Index Shopping nastojimo izdvajati odlične proizvode koji se i nama sviđaju te odlične akcije i popuste. Use INDEX and MATCH in Excel and impress your boss. ), you can either enter them directly into the function, or define variables to use instead. For example, in the example below, you can use the INDEX function to get the marks of ‘Tom’ in Physics when you know the row number and the column number in the data set. Depending on the formula, the return value of Index may be used as a reference or as a value. index(array,row_num,column_num) For the function arguments (array, etc. Excel will then display the normalized Index values in the table. So, it's very important, before using IFERROR, ensure that the formula is working correctly as you intend. Guide to What Is INDEX In Google Sheets. Read more. , A1:C10). In this way, my hope is that you get a sense of the theory t at comprise these functions. Jul 24, 2021 · The Excel HLOOKUP function finds and retrieve a value from data in a horizontal table. INDEX MATCH is a powerful combination that allows you to do simple and advanced lookups in Excel. Mar 3, 2017 · Learn to use INDEX MATCH in Excel, a better, more flexible way to lookup data than VLOOKUP. In my opinion this function is one of the most useful functions in Excel. By lookup functions I mean LOOKUP, HLOOKUP, up functions have in common. Why Use INDEX? Precision: You specify the exact row and column position Jul 1, 2023 · Learn how to use the INDEX function in Excel to retrieve specific data from tables and arrays efficiently. It will help you find the value you need quickly. See below for many examples. There are two ways to use the INDEX function: array form or reference form. Predajte oglas za svoj auto, stan, posao ili apartman POTPUNO BESPLATNO. If you can understand the theory, then the old f nctions take on new meaning. MATCH supports approximate and exact matching, and wildcards (* ?) for partial matches. Learn how to apply the Excel INDEX function using excel and VBA. In this tutorial, we’ll dive into the syntax and advantages of the INDEX MATCH formula. Jan 31, 2025 · What is the INDEX function? The INDEX function returns a value from a specific position in a cell range, Excel table, or an array based on a row and column number. Excel locates the value at that intersection and provides the result from the formula. The INDEX function returns a value or the reference to a value from within a table or range. INDIRECT is useful when you want to assemble a text value that can be used as a valid reference. It can help you search through rows and columns of data. Aug 7, 2025 · The HLOOKUP function is a efficient tool in Excel that helps we find data arranged horizontally in a table. Together, they provide a more flexible and powerful data retrieval method, especially when working with large and dynamic datasets. The function will return the value at a given position in a range or array. Better yet, new functions like XLOOKUP make a lot more sense – and Jan 16, 2024 · The INDEX function in Excel will automatically understand whether you mean the corresponding row or column. This tutorial wil Feb 9, 2024 · MATCH is an Excel function used to locate the position of a lookup value in a row, column, or table. May 4, 2024 · This article demonstrates every detail about the column index number of the VLOOKUP function. Free practice workbook available for download. Mar 14, 2025 · INDEX and MATCH is the most popular tool in Excel for performing more advanced lookups. An Alternative: FILTER functions is also used. INDEX MATCH is made up of two functions. column C, and returns the relative position for said value. Tužan sam zbog toga" ISKUSNI hrvatski trener Branko Ivanković (71) za Index komentirao je derbi Hajduk - Dinamo (0:2). To apply the Index function, right-click on any value in the Pivot Table, select Show Values As, and choose Index. This function is particularly useful when dealing with large datasets, as it provides a method of retrieving specific data points without having to manually search through the entire dataset. Here we explain how to use the SHEET Excel for cell references, examples & downloadable excel template. If you want to improve your Excel skills, INDEX and MATCH should be on your list. Learning how to use the INDEX and MATCH functions can allow you to search for values more efficiently in a sheet. To use Excel with confidence, you must have a good understanding of formulas and functions. The INDEX function is considered the predecessor of VLOOKUP and HLOOKUP. Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. com/videotutorials/index. If you've ever found yourself wrestling with large datasets and wishing for a way to effortlessly extract specific data points, then the INDEX function is about to become your Dec 28, 2024 · Excel is a powerful tool that offers a wide range of functions to help users manipulate and analyze data efficiently. In this article, we will explore how to use the INDEX function in Excel and provide detailed examples to help users understand its Learn how to use the INDEX function in Microsoft Excel. Refer to the table where HLOOKUP will look for. are the values from which to choose from. The first row in the table is row 1 and the first column in the table is column 1. Jan 16, 2025 · INDEX’s final output is a union of these rows. Oct 4, 2023 · INDEX MATCH Excel Dive into the intricate world of Excel with our comprehensive guide on INDEX MATCH, a powerful formula often used in data analysis and manipulation. Excel has 450+ functions that can do a range of awesome things. g. Apr 23, 2024 · Learn how to the definition and uses of FILTER function in Excel. It’s a flexible and strong alternative to old lookup functions. Pročitajte najnovije vijesti iz Hrvatske, regije i svijeta iz minute u minutu: ekskluzive i otkrića, komentari i analize, politika, ekonomija, crna kronika, stanje u prometu. The INDEX function Mar 17, 2023 · See how to use the IFERROR function in Excel to catch errors in formulas. Jun 14, 2024 · Here’s an overview of the functions and formulas for different types of lookups in Excel. 2. Let's learn the INDEX function Syntax and illustrate how to use the function in Excel below. May 15, 2024 · Learn how to use formulas using the INDIRECT, INDEX, and MATCH functions in Excel. Here we learn how to use it to find values as an alternative to VLOOKUP with examples & downloadable template. Jun 16, 2024 · In this article, you will learn about the AGGREGATE function in Excel. Excel is a powerhouse of a tool with a mind-boggling array of functions that can make working with data a breeze. The syntax for INDEX in Array Form is INDEX(array, row_number, column_number) with the first two arguments required and the third optional. Sad i zauvijek, jer besplatni oglasi trebaju biti - besplatni. In this article, we discuss the definition of Index Match, provide you with information on how to use these functions, share some common errors regarding Note: If you want either the INDEX or MATCH function to return a meaningful value instead of #N/A, use the IFERROR function and then nest the INDEX and MATCH functions within that function. They are essential in data analysis for referencing, cross-referencing, and extracting meaningful insights from large or complex datasets. Guide to HLOOKUP Examples In Excel. Since the function returns values from an array depending on a selected row and, optionally, column number, INDEX is Guide to What is Index Match Function in Excel. Jul 19, 2023 · Key Highlights The INDEX function in Excel helps to find the information within a data range, where it looks up values by both columns and rows. Nov 2, 2023 · The Excel SORT function sorts the contents of a range or array in ascending or descending order. Index function returns the value at a given row and column index in a table array. And what is more awesome is that one Excel function – a formula that consists of two, three, or more functions. For example =SUM(A1:A5) The range is always inside of parentheses. With detailed explanations and examples, this guide helps you grasp intricate functions like INDEX, MATCH, and VLOOKUP, bolstering your Excel proficiency level. The INDEX function then returns the value or cell reference from within a table or range. Feb 4, 2023 · INDEX Function in Excel: Returns a value or the reference to a value from within a table or range. The VLOOKUP function can only lookup a value in the first column. Learning how to use INDEX MATCH in Excel is a great workaround. In this guide, I will walk you through how INDEX() and MATCH() work individually and together, how to perform vertical and horizontal lookups, and best practices for using INDEX MATCH with practical examples. This practical example demonstrates using the INDEX function to retrieve a value from a database based on the coordinates of rows and columns in the table. We will explore its uses, aggregate data, with multiple criteria, combine aggregate with IF function, INDEX function, and aggregate vs subtotal. One such function is the INDEX function, which allows users to retrieve data from a specific cell or range of cells within a table or array. What is the INDEX Function? The INDEX Function [1] is categorized under Excel Lookup and Reference functions. One such function, which often flies under the radar but is incredibly powerful, is the INDEX function. Sep 12, 2021 · The result of the Index function is a reference and is interpreted as such by other formulas. wrr dunns tqp eheu ixuubv rgru nuqcz xslv nsgdz lvnkqy