+ Reply to Thread
Results 1 to 2 of 2

Vlookup to get Values for repeated sequence

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Vlookup to get Values for repeated sequence


    My an infant in excel

    Can you help me to get a formula that does vlookup for repeating values. Essentially i have testcase numbers attached to user stories. Multiple Test case belong to user stories. Each User Story has unique system id. On the sheet where test cases have repeating column values for user stories i want to populate the system id for given user story.

    I needthat weired string to be populated all the way down.

    Storyid storyname
    a082C000000HGDZQA4 STY-00000
    a082C000000HGDaQAO STY-00001
    a082C000000HGDbQAO STY-00002
    a082C000000HGDcQAO STY-00003
    a082C000000HGDdQAO STY-00004
    a082C000000HGDeQAO STY-00005
    a082C000000HGDfQAO STY-00006
    a082C000000HGDgQAO STY-00007
    a082C000000HGDhQAO STY-00008
    a082C000000HGDiQAO STY-00009
    a082C000000HGDjQAO STY-00010
    a082C000000HGDkQAO STY-00011
    a082C000000HGDlQAO STY-00012
    a082C000000HGDmQAO STY-00013
    a082C000000HGDnQAO STY-00014
    a082C000000HGDoQAO STY-00015

    I want to populate that string in below lookup

    TESTCASE USERSTORY Storyid (Need formula for this field that looks at Userstory and does lookup above )
    TC-00001 STY-00000 a082C000000HGDZQA4
    TC-00001 STY-00000 a082C000000HGDZQA4
    TC-00002 STY-00000 a082C000000HGDZQA4
    TC-00001 STY-00001 a082C000000HGDaQAO
    TC-00002 STY-00001 a082C000000HGDaQAO
    TC-00001 STY-00002
    TC-00002 STY-00002
    TC-00003 STY-00002
    TC-00001 STY-00003
    TC-00002 STY-00003
    TC-00003 STY-00003
    TC-00001 STY-00004
    TC-00001 STY-00005

    Attached Images Attached Images

  2. #2
    Forum Guru
    Join Date
    MS-Off Ver
    Excel 2019

    Re: Vlookup to get Values for repeated sequence

    Welcome to Excel Forum. For future reference spreadsheets are easier to work with than pictures of spreadsheets. To upload a spreadsheet click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window. (see FAQ for more info)
    As to a formula that will match stories to ID's this seems to work dependent on the layout:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Let me know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 10-11-2014, 04:52 AM
  2. [SOLVED] With repeated values in a range, Vlookup only shows adjacent values for the last one
    By fsalina in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2014, 03:19 PM
  3. insert a blank row for a missing value of a repeated sequence
    By newexcel123 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-29-2014, 01:58 PM
  4. [SOLVED] VLOOKUP giving random and repeated values?!?
    By ajasons in forum Excel General
    Replies: 6
    Last Post: 05-22-2012, 11:50 AM
  5. Replies: 9
    Last Post: 10-25-2011, 12:35 PM
  6. [SOLVED] Append data to repeated values with a fixed array to be repeated on value change
    By anchuri_chaitanya in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-06-2011, 12:30 AM
  7. [SOLVED] create list of unique values from a column with repeated values?
    By Chad Schaben in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

Tags for this Thread


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