Now have two forms, one is to buy insurance personnel list, a list is a monthly employee, how can I quickly in buying insurance personnel list to select the employee list?

Methods of soil is now, each name search again, very tired

CodePudding user response:

Use the SQL query?

CodePudding user response:

Vlookup function

CodePudding user response:

Just like the above comment, recommend using VLOOKUP, if name repetition, however, may have some trouble, if you have id number, according to the id card contrast is best,

CodePudding user response:

vlookup

CodePudding user response:

Agree, using vlookup's name is not the only, can let person for table 2 edge has a unique label is better, not only first name under human to verify again,