STDEVPA question

[Guest]

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]

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!

 

[Guest]

It worked like a charm.
Thanks Dominic

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!