STDEVPA question

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

Assumptions:

A1:D10 contains your lookup table

F1 contains your lookup value

Formula:

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

Adjust the ranges accordingly.

Hope this helps!

In article <[email protected]>,
"RD Wirr" <[email protected]> wrote:

> 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

It worked like a charm.
Thanks Dominic

"Domenic" wrote:

> Assumptions:
>
> A1:D10 contains your lookup table
>
> F1 contains your lookup value
>
> Formula:
>
> =STDEVPA(INDEX(B1:D10,MATCH(F1,A1:A10,0),0))
>
> Adjust the ranges accordingly.
>
> Hope this helps!
>
> In article <[email protected]>,
> "RD Wirr" <[email protected]> wrote:
>
> > 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
>