lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I have table like below, user will enter age and I want excel to return the name, so I did match/index function like this
=INDEX(A2:D7,MATCH(G4,D2:D7,0),1)
G4 = age
Now if user enter G4 = 40 excel will return john, how can I ask excel to return linda as well. I am thinking it must be array formula, am I right? Thank you
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
I have table like below, user will enter age and I want excel to return the name, so I did match/index function like this
=INDEX(A2:D7,MATCH(G4,D2:D7,0),1)
G4 = age
Now if user enter G4 = 40 excel will return john, how can I ask excel to return linda as well. I am thinking it must be array formula, am I right? Thank you
name | phone# | address | age |
john | 1 | 1 main st | 40 |
mary | 2 | 3 east ave | 50 |
lary | 3 | 5 west blvd | 60 |
linda | 4 | 7 main st | 40 |
mike | 5 | 11 east ave | 20 |
sue | 6 | 6 main st | 30 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>