How to use name to find location in excel2016

Open excel2016, create a basic table header, and adjust the cell width and height to make the whole look coordinated. Here is a trick for you. Press the Alt Enter key to wrap lines in the cell, and then enter the following function formula in cell F1: =IF(D1=0,"",IF(D1>1,MATCH(D1,B: B),""))

Explain the meaning of the formula: IF() function: determine whether a condition is met. If it is met, it returns a value. If it is not met, it returns another value. . MATCH function: Returns the corresponding position of the element in the array that matches the specified array in the specified way. If you need to find the position of the matching element rather than the matching element itself, you should use the MATCH function instead of the LOOKUP function. So the meaning of this formula is to judge the value of cell D1. If it is a null value, return a null value; if it is not a null value, match the value entered in cell D1 of column B, that is, return the corresponding row number.

The following editor will explain it in detail with specific examples. As shown in the figure, some data will be created for testing.

For example, enter John Doe in cell D1 and see what value cell F1 will return.

OK, the returned value is 4. In the table below, we can see that the row number of Li Si is 4 and the serial number is 2. What is returned here is not 2, but 4. Everyone Don't be fooled by the serial number. The meaning of the formula is to return the number of rows of the specified content.

The above is the detailed content of How to use name to find location in excel2016. For more information, please follow other related articles on the PHP Chinese website!