1. ## LOOK UP Problem

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.

2. What is the current function you are using?

3. Originally Posted by NBVC
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

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•