In the salary, because there are attendance bonuses, accommodation fees, social security fees and so on, in another table, how to put these data tables into the salary table?

Let's talk about the function VLOOKUP first, and the formula is as follows: =VLOOKUP(A 1, Sheet2! A 1: d300,2,0) Then a1in brackets is the condition value you use to find, such as Zhang Haixia, Sheet2! A 1:D300 is the range from a1to D300 in worksheet 2, that is, the area where the data you are looking for is located. Of course, it can be other worksheets. 2 means to return the value in the second column, that is, A 1 in Table 2 is Zhang Haixia, and B 1 is 100, so attendance award is awarded. If the accommodation fee is changed from C 1 to 3, the value in the third column is returned. By analogy, the last 0 indicates an exact search, that is, the corresponding value will be returned only if the conditions are fully met. If it is changed to 1, it means approximate search. For example, if there is a Zhang Haitao, the value of Zhang Haitao will be returned, but Zhang Haixia will not be found, so 0 means that only the value of Zhang Haixia will be returned. This is called exact search. You only need to use it once to understand, and you will use it again.