Retrieving Employee Contact Information
As an HR Coordinator, I often need to quickly find an employee's phone number or email address, especially during urgent situations or when updating records. Manually sifting through a large employee roster is inefficient. I need a reliable way to pull specific contact details using their unique Employee ID (e.g., from cell E2).
=VLOOKUP(E2,A2:C5,3,FALSE) How it works: This formula takes the Employee ID from cell E2 and searches for it in the first column of your employee data range (A2:C5). Once the matching Employee ID is found, it retrieves the corresponding value from the third column of that row, which is the employee's phone number. 'FALSE' ensures that only an exact match for the Employee ID is accepted.
Data Setup
| Employee ID | Employee Name | Phone Number |
|---|---|---|
| EMP001 | Alice Smith | 555-1234 |
| EMP002 | Bob Johnson | 555-5678 |
| EMP003 | Charlie Brown | 555-9012 |
| EMP004 | Diana Prince | 555-3456 |
Step-by-Step Guide
Enter the Employee ID you need to look up into a cell (e.g., E2).
In the cell where you want the phone number to appear, type the VLOOKUP formula.
Specify the lookup value (E2), the table array containing employee data (A2:C5, assuming your employee roster is in columns A to C starting from row 2), the column index of the phone number (3, as Phone Number is the 3rd column in A:C), and 'FALSE' for an exact match.
Press Enter to display the employee's phone number.