The formula to enter, in the cell range M8:15 is =VLOOKUP($L$6,$A$6:$J$13,2,FALSE)
<h3>What are Excel formulas?</h3>
Excel formulas are formulas that are used together with functions to perform arithmetic and logical operations
<h3>How to copy the formula?</h3>
From the complete question, the formula in cell M7 is:
=VLOOKUP($M$6,$A$6:$J$13,2,FALSE)
The above formula uses absolute style of referencing.
This means that when the formulas are copied, the formulas would remain unchanged.
So, the formulas in the range M8 : M15 are:
=VLOOKUP($M$6,$A$6:$J$13,2,FALSE)
From the question, we understand that the column labels M are to be changed to label L.
So, the updated formula is:
=VLOOKUP($L$6,$A$6:$J$13,2,FALSE)
Hence, the formula to enter, in the cell range M8:15 is =VLOOKUP($L$6,$A$6:$J$13,2,FALSE)
Read more about Excel formula at:
brainly.com/question/14299634
#SPJ1
<h3>Complete question</h3>
Copy the formula in cell M7 is =VLOOKUP($M$6,$A$6:$J$13,2,FALSE) to the range M8:M15, and edit the copied formulas to return the value from the column indicated by the label in column L
