Search employee names by ID
In business, employee lists in excel are frequency used in a lot of companies.
And sometimes we extract some data from the lists.
In the case, the Vlookup Function is absolutely useful.
Well then, let’s introduce the function for improve your desk works.
Vlookup Function
Sample data
Now we have prepared the following excel sheet.
The right table represents all employee list, and the left table represents participant list.
The cells C3:D5 of participant list are blank.
we aim to fill the cells using the vlookup function.
How to use vlookup
The vlookup function has 4 arguments.
- lookup_value: search keyword
- table_array: the range where the lookup value is located
- col_index_num: the column number of the range
- range_lookup: optional, exact or partial match
Extract employee name
First of all, fill in the following text in cell C3.
=vlookup(B3,$F$3:$G$14,2,false)
In the test of the article, please use ID for the first argument.
Next, use an absolute reference for the second argument.
Thanks to absolute reference, we are able to use autofill.
We can use autofill to quickly fill in the below lines.
To extract other information, change the range and column number.
In the article example, we can extract the department with the following text.
=vlookup(B3,$F$3:$H$14,3,false)
We can fill everything using autofill as well.
Then, all objectives completed.
Conclusion
In this article, the vlookup function is introdused.
- Vlookup function is useful for extacting information
- The function has 4 arguments
- Absolute reference is used for the range
