excel a condition with formula matching to show multiple results?

If it's good, you can only use formulas to match, and when it comes out, you can show multiple results.

If this happens, it is recommended to refer to the relevant instructions, or ask their professional staff to help you solve it directly.

1. Open Excel, click "File" in the upper left corner, click "New", and create a new Excel document.

2. Enter the "formula" in the text box, click the "Create" button, and you can see the use of various pants and wide rolls. Multi-condition matching can be achieved using sumproduct, sumifs functions, and advanced filtering methods, and the principle of the functions can be found in Excel help.

3. At the bottom of the page, you can find the use of "multi-condition function".

4. The summary is as follows.

1. Open your excel.

2. For example, there is a price list of mobile phones of various brands in different regions, and now you need to find out what the price of a certain brand is in a certain region.

3. Select the Square Grid tab.

4. Find the "Multi-Condition Search" command under the "Find and Locate" button.

5. In the pop-up window, you need to tell it the location of 4 regions: conditions, condition areas, data areas, and result storage.

6. After completion, you can confirm it. That's the result of using the formula.

1. First of all, we need to open the original excel**, which already has some data, as shown in the figure below, with names and their numbers in the figure.

2. Open another ** that needs to match data, in this ** there are already the names of these people, but there is no number of them. In addition to copying their numbers one by one into this one, we can also use the function formulas in excel to match the data.

3. Now select a numbering box in the matching table, and then enter the function formula to match the data.

4. In the cell, first enter = in the English input state, and then enter the vlookup function formula, and then some prompts will appear in parentheses after the vlookup function, and select the cell according to the prompts.

5. After selecting the contents according to the prompts, click the Enter key to get the numbered data, and then you can complete the matching of all the numbers after dropping down and filling.

Formulas can be used.

vlookup(j1,sheet1!f:g,3,false) lookup value: j1, with part number as the lookup value;

Data sheet: sheet1!e:g。

For array formulas, you need to press the Ctrl Shift Enter key at the same time, and the result will appear, drop down the formula.

Column E cannot be empty.