- Picture and text skills
When faced with huge amounts of employee information at work, HR personnel often use the VLOOKUP function to create employee information lookup tables.
The following will demonstrate how to use the VLOOKUP function to create an employee information query table.
■ Taking this employee information table as an example, first set the drop-down menu of the lookup table.
Click Data - Validity in the menu bar above, select the validity condition as "Sequence" in the pop-up dialog box, and the source is A3:A8.
Click OK, and then click on the employee's name to query.
■Then use the VLOOKUP function to query employee information based on the employee's name.
Place the cursor at H3 and click to insert the VlOOKUP function.
Enter G3 in the lookup value and A3:E8 in the data table.
Since we are looking for gender, enter 2 in the column number.
TRUE is fuzzy matching, FALSE is exact matching, enter FALSE here.
Click OK to match the employee's gender based on the employee's name.
Other information can be deduced in the same way. If you select the name at this time, the query form will automatically display the relevant information of this employee.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/ren-shi-xing-zheng-ji-qiao-VLOOKUP-han-shu-zhi-zuo-yuan-gong-xin-xi-cha-xun-biao.html
评论列表(196条)
测试