I need to know how to fill the formula into a range on excel after applying the VLOOKUP function?

2. Delete the conditional formatting rule applied to th 3. In cell E2, enter a the HLOOK e range D2:D31. formula using the HLOOKUP function and structured ermine a staff member's pay rate (which is based on the references to det number of years of service). a. Use a structured reference to look up the value in the Service Years column. Retrieve the value in the 2nd row of the table in the range Q15:U16. Since staff members service, find an approximate match. do not receive a raise after every year of b. Fill the formula into the range E3:E31 if necessary. 2. Delete the conditional formatting rule applied to th 3. In cell E2, enter a the HLOOK e range D2:D31. formula using the HLOOKUP function and structured ermine a staff member's pay rate (which is based on the references to det number of years of service). a. Use a structured reference to look up the value in the Service Years column. Retrieve the value in the 2nd row of the table in the range Q15:U16. Since staff members service, find an approximate match. do not receive a raise after every year of b. Fill the formula into the range E3:E31 if necessary