LOOK UP Problem

Seema

New member
Joined
Jun 6, 2013
Messages
2
Reaction score
0
Points
0
Hi This is my first visit to this forum. I am a medical doctor working in Sub-Saharan Africa and I dont have any formal training on Excel.
I am trying to flag "areas" for prioritized action on Health issues. ...
SO I want to index, "Area names" from Column A, by Matching Values in Column T3:T28, against T2.....The fuction works for the first selection.....My problem is after the function picks up the first "Area" from Column A, it keeps picking the same "area" and does not go on to Index areas in the whole of Match values in T3:T28
I hope I am conveying my problem.
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
What is the current function you are using?
 

Seema

New member
Joined
Jun 6, 2013
Messages
2
Reaction score
0
Points
0
What is the current function you are using?
I am using Excel..
=INDEX(A4:A28,MATCH(T2,T4:T28:T28,-1)+1)
This brings up the first area but when I try to pull down the formula it keeps Indexing the first "area" again..I tried the formula given below But it does not work
=IF(AI4<T2,INDEX(A4:A28,match,INDEX(A5:A29,MATCH(T3,T5:T29:T29,-1)+1)))
I Dont even know how to repond to you email as I am new to this forum
Thank you SO much
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Try:

=IFERROR(INDEX($A$4:$A$28,SMALL(IF($T$4:$T$28=$T$2,ROW($A$4:$A$28)-ROW($A$4)+1),ROWS($A$4:$A4))),"")

This is an ARRAY formula, and so you need to confirm it with CTRL+SHIFT+ENTER not just ENTER, then copy it down.
 
Top