Formula to find specific value

[joyrock37]

Hi All,
I need a solution for the following problem:

I have two arrays. The formula in the red column in array1 is supposed to get the value from the third column in array2, based on these conditions:

Group (Array1) matches Group (Arrray2)
AND
Age (Array1) <= Maximum Age (Array2)

Array1

Group	Age	Formula required to result in
c	3	young
c	6	old
c	9	old
d	4	old
d	8	old

<tbody>
</tbody>

Array2

Group	Maximum Age	Code To Get
c	4	young
c	9	old
d	3	young
d	10	old

<tbody>
</tbody>

I have tried array functions, but no success.

Thank you for lending your brain

 

[jasonb75]

See if this helps

Excel Workbook
	A	B	C
1	Group	Age	Formula required
2	c	3	young
3	c	6	old
4	c	9	old
5	d	4	old
6	d	8	old
7	*	*	*
8	Group	Maximum Age	Code To Get
9	c	4	young
10	c	9	old
11	d	3	young
12	d	10	old
Sheet1

 

[joyrock37]

Friggin' AWESOME! Thank you sooooo much, you ROCK