You would need to use INDEX MATCH, a really well laid out tutorial can
be found here 'INDEX MATCH - Excel Index Function and Excel Match'
(
http://www.contextures.com/xlfunctions03.html) Debra has even included
a dowloadable example workbook.
QUOTE=Maricarmen;723367]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?
--
Simon Lloyd
Regards,
Simon Lloyd
'Microsoft Office Help' (
http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.thecodecage.com/forumz/member.php?u=1
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=202605
http://www.thecodecage.com/forumz