In cell M3 i have the formula =INDIRECT("C"&M1) M1=the value 3, so my formula is basically calling for the value that is in cell C3.
How would I edit the formula, so that when I drag down, it will give me the values that are in cells C4, C5, etc.
How would I edit the formula, so that when I drag down, it will give me the values that are in cells C4, C5, etc.