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...