Two working table, table inside a name and the name of the table 2 for duplicate, but one more than table 2, table now to put the table in the name of the corresponding bonus grab to the table, behind the name of the corresponding, the names of the two tables is sort of, kind please help once, please

CodePudding user response:

Can use a vlookup formula (), table 1 C is usually listed as a bonus, C2=iferror (vlookup ($a2, table 2! A: B, 2, 0), "")
Name, however, may not be a good retrieval keywords, there should be a employee number or id number has uniqueness,

CodePudding user response:

Sumifs, lookup, whether can be realized

CodePudding user response:

In general has been written on the second floor, which is using vlookup function, but the premise shall be the same on both sides of the corresponding Chinese name, or is not to be able to pull the

CodePudding user response:

reference 1/f, zara's reply:

can use a vlookup formula (), table 1 C is usually listed as a bonus, C2=iferror (vlookup ($a2, table 2! A: B, 2, 0), "")
Name, however, may not be a good retrieval keywords, there should be a employee number or id number has uniqueness,

Positive solution, vlookup formula () the most suitable for use in this scenario,