L
LOC
I have a range of numbers - effect sizes AD2:AD47. In another column AP, I
want write a formula that will look up the percentile conversion within the
same worksheet. The percentile conversion list the estimate effect size in
Column A - AQ2:AQ22 and then the percentile is in AR2:AR22. So in other
words, if the effect size is 0.4 in AD2 then AP 4 would look in AQ:AQ22 and
say found the value in AQ19 and then return the value that appears in AR19.
So my question is . . . how would I write the formula?
want write a formula that will look up the percentile conversion within the
same worksheet. The percentile conversion list the estimate effect size in
Column A - AQ2:AQ22 and then the percentile is in AR2:AR22. So in other
words, if the effect size is 0.4 in AD2 then AP 4 would look in AQ:AQ22 and
say found the value in AQ19 and then return the value that appears in AR19.
So my question is . . . how would I write the formula?