Question: I need the correct answer for this question please = 1 . Brittany Lambert is a volunteer for the Brevard County Swim Clubs in Melbourne,
I need the correct answer for this question please
Brittany Lambert is a volunteer for the Brevard County Swim Clubs in Melbourne, Florida, and has offered to compile data on the swim club employees and teams. She needs your help completing the workbook and analyzing the data.
Switch to the All Employees worksheet. In cell E enter a formula using the XLOOKUP function as follows to determine an employee's potential pay rate, which is based on their years of experience:
a Use a structured reference to look up the value in the Years of Experience column. Find the matching value in the range P:U and retrieve the value in the range P:U using absolute references to both ranges. Return nothing if the lookup value isn't found, and since hourly pay rate is tiered based on the number of years of experience, find the next smallest match.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
