-
Anonymous users2024-02-07Material Tools: Excel2010
1. Open Excel2010, in the following figure, we want to find out the results of the person with the corresponding name and gender, first select the C2 column to find the vlookup function.
2. Enter the search conditions A2 and B2 in the search value, and we use a combined symbol in the middle.
3. Enter an if function in the data table, followed by the data ** searched, and the name and gender of the same data ** are combined with symbols.
4. In the column ordinal, it should be noted that the combined name and gender are counted as 1 column, and the score we are looking for is in the second column.
5. After all the input is completed, the most important thing is to hold down the shift plus ctrl and enter keys at the same time to see the results.
6. Pull down the formula to the last one, and all the corresponding results will appear, and we can simply verify it after doing the formula, and find that there is no problem after verification.
-
Anonymous users2024-02-061. If you want to reference the data in column C to column D, enter the key combination of CtrlshiftEnter in cell D2 to realize the reference. 3. vlookup (find the value of Xiannian Zheng, find it in **, return the data of the first column, the logical value after finding it), where the logical value is true or false. This is a layman's explanation of the high-elimination syntax of the vlookup function.
4. if(, equivalent to if(, is used to sell the data of Zaozhou to construct the search range. And if(,a2:a7& deficit b2:
B7, C2:C7) cousin hymn to merge the data of columns A and B into one column; Column C data as a column. In this way, the search area is two columns, and 2 in the formula represents the number of beats in the second column (that is, column c) of the search area.
-
Anonymous users2024-02-05When using excel for office, there may be a lot of times when you need to use functions for multi-condition query, maybe there are friends who don't know how to use multi-condition query, the next is the method I bring to you to use excel to use functions for multi-condition query, for your reference.
How to perform multi-condition query with functions in excel:
Multi-criteria query step 1: How to use the corresponding score of column C according to the class in column A and column B name? Take a look at the diagram below.
Multi-condition query step 2: After the formula is entered in the above figure, because the formula contains an array, press Ctrl+Shift+Enter at the same time. The function is explained in segments below.
Multi-criteria query step 3: First, look at e2&f2 in the formula, which means that two cells are connected together as a whole for searching.
Step 4: A2:A7&b2:B7 is basically the same as above, that is, the class and the name as a whole.
Use. if function.
Insert the original formula to directly exclude the case where the calculation result is 0. >>>More
1. To sum the cells in the region that meet multiple conditions, you can use the sumifs function. >>>More
1. Select A1 first, and then use Format Conditional Format in the menu, when its value is equal to A1, set the "Format" to red; In the same way, do the b1 conditional grid, then select these two cells, click the format brush, brush the possessive box below, because the data is too long, so you can divide the window into two departments first, and the lower department is located to the end with ctrl end. >>>More
Do you checkbox1 have to be checked? If not, this error will occur. Otherwise, you can change the first sentence to a fixed one. Also, you can show your SQL to see if it's right.
1. Tools >> >> >> >> >> >> >"Iterative calculations"checkbox. >>>More