USE OF FUNCTIONS FOR FINDING AND REFERENCING IN EXCEL

First of all, you have a table of definitions of which person is which group of the whole staff, right? Add a column to the exported summary table, such as "Grouping". Then, use the formula vlookup function to define the names of the people in each row of data in the definition table.

Your v4496 has several directly use vlookup, xlookup is not working.

If you have to, add 2 columns to the left of each table as a secondary column.

A2 input =countif($b$2:b2,b2)&b2 and then pull down.

Enter e2 =countif($f$2:f2,f2) and pull down.

H3 input =xlookup(e2&f2,a:a,c:c,"Not found",0) Then pull down, it's OK If your version doesn't support xlookup, it's okay to use vlookup

Why is there no row number in the screenshot?

Suppose in the ABCDE column.

v4496 on d2

e2=vlookup(e2,a:b,2,0).

1. First of all, you need to insert the vlookup function in column D3, click Find and Reference, as shown in the figure below.

2. Select the vlookup function from the drop-down menu, and the vlookup function parameter dialog box will pop up.

3. Set the relevant parameters in the function parameter dialog box of vlookup, the first parameter is the C3 employee category, and at the same time, it should be noted that the employee category of column C and the employee category of column G should be consistent, otherwise it is not easy to find the corresponding data, if it is a number, pay attention to the consistency of the format, without formulas, etc., otherwise there will be errors.

4. The second parameter is the post and bonus distribution table, and the value of the post salary is ** the value of the post salary in the post and bonus distribution table, so the second parameter of which fiber should include the post salary, and at the same time include the category of the employee, column G is used to correspond to the data of column C.

5. The third parameter is the position of the corresponding post salary result in the post and bonus distribution table, the value of the post salary is in the second column, so the third parameter is filled in 2, note that the number of columns here corresponds to the number of columns of the second parameter selected data, and the fourth parameter, 0 is indicated"false", you can also directly enter the English false, which is used to specify the exact search when the function is found, and if it cannot be found, it will return an error message.

6. After clicking OK, you can fill in the corresponding post salary, open vertically and double-click the lower right corner of the cell to fill in the post salary after that, and copy and use the formula.

7. The subsequent bonus can be calculated with the same vlookup function, inserting the vlookup function in the cell of e3, the difference is that the second parameter should contain the bonus column, and the position of the third parameter corresponding to the data is the third column, so the third parameter should be written with 3.

8. After clicking OK, the corresponding bonus value will appear, and the same click on the lower right corner of the cell to pull down, you can copy the formula and appear the required value.

Enter the formula: =vlookup(Condition 1 & Condition 2, if(, Condition 1 region & Condition 2 region, return column), 2, 0).

Finally, press Ctrl Shift Enter at the same time to finish.

Explanation: 3. IF(,A2:A7&B2:B7,C2:C7) means that the class and the name are taken as a whole, and then combined with the score column into two columns, that is, the class name is one column as a whole, and the score is one column.

4. Finally, use vlookup to find the corresponding "score" of "class name as a whole" from the column of "class name as a whole" and the column of "score".

Answer]: a, b, c

SLN is used to return the depreciation value of each period of a certain asset with the straight-line method, which does not conform to the topic, and the other three items belong to the function of finding and sheding this guideline, so the three ABC items are selected.

Answer]: a, b, c

SLN is used to return the depreciation value of an asset calculated by the straight-line method, which is a basic financial function and does not conform to the topic, and the other three items belong to the function of finding the closed macro band and referencing the absolute silver, so choose A, B, and C.