USA: +1 (725) 712-1730 
Sign in
13. In cell Q4, enter a formula using the VLOOKUP function to display a staff member’s years of service. Look up the staff ID listed in cell Q2. Use a structured reference to retrieve the value in the 4th column of the CBFStaff table. Since the formula is looking for a specific staff member’s data, find an exact match.
Expert Answer
More Answers
The following image shows how to use VLOOKUP for the required purpose.
You need to use the command:
=VLOOKUP(B5,B2:D13,3,FALSE)
B5 here refers to the ‘id’ of staff whose data is needed. B2:D13 are the starting and ending cells of the table. 3 is the column number whose value is required as output. Here, it is ‘years of service’. False asserts that an exact match will be searched for.
