EXCEL

[Maricarmen]

I got a table with values for age, gender, percentiles like
BOYS
AGE 5% 10% 25%
6 100 115 127
7 112 116 129

GIRLS
AGE 5% 10% 25%
6 100 115 127
7 112 116 129

If I have those values of the book and i want to get the value that
corresponde in the table. How I can do it?

 

[Brad]

I think you want to use a vlookup

http://www.google.ca/search?hl=en&r...B&q=Excel+vlookup&aq=f&aqi=&aql=&oq=&gs_rfai=

Brad

 

[Chip Pearson]

It isn't entirely clear what you are looking for, but maybe the
following will get you going in the right direction. Suppose your boys
table is in cells B3:E5 and the girls table is in B8:E10. If the
gender you want to look up is in H1, the age to look up is in I1, and
the percentage to look up is in J1, the following formula will return
the value from within the table for a specified gender, age, and
percentage:

=OFFSET(IF(H1="boys",B3,B8),MATCH(I1,IF(H1="boys",B3:B5,B8:B10),0)-1,MATCH(J1,IF(H1="boys",B3:E3,B8:E8),0)-1)

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com