+ Reply to Thread
Results 1 to 2 of 2

Index & Lookup returning data for only 1st or last occurance of matched key value.

  1. #1
    Registered User
    Join Date
    12-29-2010
    Location
    Terre Haute, IN USA
    MS-Off Ver
    Excel 2003 & Excel 2010
    Posts
    1

    Question Index & Lookup returning data for only 1st or last occurance of matched key value.

    Building a spreadsheet which matches values in a 2 column table and returns the
    value for each occurance of the key value. So far able to get the first key value occurance using "=IF(INDEX($A$2:$B$8,MATCH($K28:$K34,$A$2:$A$8,0),2)=K$19,"X","")"
    and the last key value occurance using "=IF(VLOOKUP($K10:$K16,$A:$B,2,1)=K$1,"X","")".
    How do I get the formula to return info from all occurances of a repeated key value in the look up table?

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Index & Lookup returning data for only 1st or last occurance of matched key value

    Take a look at the attached, which uses a helper column.

    Cell F1 contains the input value
    Column-G contains the look up formulas
    Attached Files Attached Files
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1