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.
The following image shows how to use VLOOKUP for the required purpose.
Don't use plagiarized sources. Get Your Custom Essay on
Answered! 13. In cell Q4, enter a formula using the VLOOKUP function to display a staff member’s years of service. Look up the…
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS $13/PAGE
You need to use the command:
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.