how to combine an IF Function with a lookup function to determine

[Guest]

I have two charts. I have to combine an IF function with a lookup fuction to
determine the value in the last column of the first chart.
The value is to determine minutes allowed based on age and gender.
The time varies by gender. That information is in the second chart.

 

[ryanb.]

I have two charts. I have to combine an IF function with a lookup fuction
to
determine the value in the last column of the first chart.
The value is to determine minutes allowed based on age and gender.
The time varies by gender. That information is in the second chart.

================================
take a look at

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

HTH,

ryanb.