Hi Yousuf,
thanks for your reply. This formula actually working for males only but not for females too.
C2 is age which will change from patient to patient and D2 is sex (male or female) and I5 is value which changing, but I need to enter to formula options of IF for C2 age and D2 sex.
It means that VLOOKUP should find result depends on both-sex and age cell. Actually lines of ages are in the same line, but sexes are in different columns.
ABSI-mean for males are located within column
E on Sheet2, while
ABSI-sd are within
column F.
For females ABSI-mean are located within
column J and
ABSI-sd within
column K.
I'm sorry if I'm bothering you a lot