Formula to find specific value

joyrock37

New Member
Joined
Oct 14, 2011
Messages
26
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
GroupAgeFormula required
to result in
c3young
c6old
c9old
d4old
d8old

<tbody>
</tbody>

Array2
GroupMaximum AgeCode To Get
c4young
c9old
d3young
d10old

<tbody>
</tbody>

I have tried array functions, but no success.

Thank you for lending your brain (y)
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
10,883
Office Version
  1. 2019
Platform
  1. Windows
See if this helps

Excel Workbook
ABC
1GroupAgeFormula required
2c3young
3c6old
4c9old
5d4old
6d8old
7***
8GroupMaximum AgeCode To Get
9c4young
10c9old
11d3young
12d10old
Sheet1
 

Watch MrExcel Video

Forum statistics

Threads
1,109,518
Messages
5,529,314
Members
409,863
Latest member
stacy09
Top