IN EXCEL, HOW DO I FIND THE CORRESPONDING NUMERIC VALUE BY FORMULA?

Use the array formula to solve it, which is convenient and easy to understand, use the choose function to construct a new sequence, and cooperate with the vlookup function to achieve the purpose.

The specific formula of the vlookup function is an array formula, and you need to press Ctrl Shift Enter at the same time.

The array constructed by the choose function is as follows: the specific formula is an array formula, and you need to press Ctrl Shift Enter at the same time

If in doubt, you can continue to communicate!

1. We enter the formula =1+2 in cell B3 and 3 in cell C3

2. Ctrl+F to open the "Find and Replace" dialog box. We select "Formula" in the search field and enter "3" in the search content.

3. Select "Formula" in the search range and enter "1" in the search content, you can find that the formula containing 1 is also found, and the non-formula numerical cell containing 1 is also found.

4. Ctrl+F to open the "Find and Replace" dialog box. We select "Numeric Value" in the search range and enter "3" in the search content, and we can find that the search range is "Numeric".

5. The search range "value" and "formula" are for the cells containing the formula, and we ignore the formula itself when looking for the range "value", and only find the result obtained by the formula when looking for the "formula", and we look for the formula itself when looking for the "formula", and ignore the result obtained by the formula.

To find the contents of the table in the calculation, use the vlookup function. Before using the vlookup function, please arrange the table into a vertical column, that is, the order 1 to 100, the percentage 0% to 100%, and the corresponding values in the order of a, b, and c, instead of placing them in two parts as now. Let the number to be found be d1 and the result be e1, please enter the formula: in e1

vlookup(d1,$b$1:$c$100,2,true). In the above formula, the search result is that if the number cannot be found, then find the corresponding value less than the maximum value of the number, as you said, there is no in the table, then find the corresponding 3362 corresponding to 22%.

Is it the result you want?

Use the formula: lookup(1,0 ((b$2:b$100=.)"3rd grade")*(c$2:

c$100=large(if(b$2:b$100="3rd grade",c$2:c$100),2)))a$2:

a$100)

For array formulas, you need to press the key combination (Ctrl+Shift+Enter) to complete the formula.

1. We enter the formula =1+2 in cell B3 and 3 in cell C3

2. Ctrl+F to open the "Find and Replace" dialog box. We select "Formula" in the search field and enter "3" in the Judgment Search Content.

3. Select "Formula" in the search range, and enter "1" in the search content, you can rush to discover, the formula containing 1 is also found, and the non-formula numerical cell containing 1 is also found.

4. Ctrl+F to open the "Find and Replace" dialog box. We select "value" in the search for Fan Sanchong and enter "3" in the search content, and we can find that the search range is "value".

5. The search range "value" and "formula" are for the cells containing the formula, and we ignore the formula itself when looking for the range "value", and only find the result obtained by the formula when looking for the "formula", and we look for the formula itself when looking for the "formula", and ignore the result obtained by the formula.

1. Click the "Select All" button in the upper left corner of the worksheet to open the "Format Cells" dialog box, uncheck the "Lock" checkbox in the "Protection" tab, and click the "OK" button;

2. Press the key or key, click the "Positioning Condition" button in the pop-up "Positioning" dialog box, select the "Formula" option and click the "OK" button

3. After locating the cell containing the formula, follow the method in step 1 to format the cell, and select the "Lock" checkbox in the "Protection" tab.

4. Click the Review tab, click the Protect Worksheet button in the Change group, enter the password (optional) and click OK in the pop-up Protection Worksheet dialog box.

App targeting implementation.

Suppose ** is as follows, and the C column is a formula column.

Step 1: Select the area you want to find.

Step 2: Press the "F5" key or press Ctrl+G at the same time to pop up the positioning dialog box.

Step 3: Select "Targeting Criteria" and select "Formula" in the pop-up dialog box.

Finally the cells with the formula are selected.

Excel is a method that uses a formula to find cells containing a field within a region and return the value. Bridge Bench Rock.

Refer to the following:1Open the excel worksheet and click the cell to proceed as below screenshot shown.

2.Click "Formula" in the menu bar and select "Insert Function", as shown in the figure below.

<>4.The function parameter setting window pops up, and vlookup(e2,a:b,2,0) is entered in the coarse starvation value.

5.Enter "Unregistered" at n a (set according to your own requirements).

6.Finally, click OK and drag the cells down to get the corresponding values.

Enter or copy and paste the following formula in D2.

vlookup(b2,,2,)

Pull-down padding.

Use the if statement formula to get the matryoshka doll: =if(cell="price reduction",30,if(cell="maintain",25,20)), note that the double quotation marks are in English format.

If there is a fourth condition, you can continue to add an if statement to the false value of the second if statement to continue the nesting doll.

An array formula is required, illustrated by the following example:

1.There are two conditions here, which correspond to the only data in the third column:

2.When we need to meet both condition 1 and condition 2 data, we need to use vlookup's multi-condition lookup, enter the array formula in cell i2 and then press the key combination to end the input.

3.Then you can complete the query of the data that meets the two conditions, and you can drag and drop it down to fill it.