Results 1 to 4 of 4

Thread: LOOK UP Problem

  1. #1

    LOOK UP Problem



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,490
    Articles
    0
    Excel Version
    Excel 2016
    What is the current function you are using?


  3. #3
    Quote Originally Posted by NBVC View Post
    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. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,490
    Articles
    0
    Excel Version
    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.


Posting Permissions

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