STDEVPA question

RD Wirr · Dec 11, 2005

I need to run a standard deviation STDEVPA on rows of numbers from a table of
data. I need to lookup a reference and then return a row of numbers right of
that reference to run the STDEVPA on. VLOOKUP doesn't do it since it can only
return one cell value. Does anyone have an idea how to find a row of numbers
and then return it to run the analysis?
Thanks,
RD Wirr

Domenic · Dec 11, 2005

Assumptions:

A1

10 contains your lookup table

F1 contains your lookup value

Formula:

=STDEVPA(INDEX(B1

10,MATCH(F1,A1:A10,0),0))

Adjust the ranges accordingly.

Hope this helps!

RD Wirr · Dec 12, 2005

It worked like a charm.
Thanks Dominic

Domenic said:
Assumptions:

A110 contains your lookup table

F1 contains your lookup value

Formula:

=STDEVPA(INDEX(B110,MATCH(F1,A1:A10,0),0))

Adjust the ranges accordingly.

Hope this helps!