The INDIRECT function in Excel returns the reference specified by a text string. 1. For example, the INDIRECT function below reduces to =INDIRECT(“C2”), =C2, 5 Do we really need the INDIRECT function for this? Yes. Below you can find the result without using the INDIRECT function. 2. For example, the function below reduces to =SUM(INDIRECT(“E3:E6”)), […]
This example teaches you how to find the cell address of the maximum value in a column. 1. First, we use the MAX function to find the maximum value in column A. 2. Second, we use the MATCH function to find the row number of the maximum value. Explanation: the MATCH function reduces to =MATCH(12,A:A,0), […]
This example teaches you how to lookup a value in a two-dimensional range. We use the MATCH and INDEX function. Below you can find the sales of different ice cream flavors in each month. 1. To find the position of Feb in the range A2:A13, use the MATCH function. The result is 2. 2. To […]
A drawback of the VLOOKUP function is that it can only look up values in the leftmost column of a table. However, sometimes you need to look up a value in any column and return the corresponding value to the left. To achieve this, simply use the INDEX and the MATCH function. 1. The MATCH […]
