Results 1 to 4 of 4

Thread: Lookup formula/ macro

  1. #1

    Exclamation Lookup formula/ macro



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

    Good morning all,
    I have a requirement to do a lookup, which i believe might need a 3d function.
    I have a spreadsheet that has multiple tabs that depict different areas in various applications. And one tab that has a list of requirements. Within the various application tabs, against each line item I have the requirement it is mapped to. What I am looking to do is in the requirement tab, have one column that has list of all the applications that are mapped to this requirement. An example is as below - the last table depicts what the resultant output should look like (in the bolded column):
    Application A tab:
    Screen ID Req ID Screen Name Comment
    123 1 Test 1
    456 1 Test 2

    Application B tab:
    Screen ID Req ID Screen Name Comment
    789 1 Test 3
    ABC 2 Test 4

    Application C tab:
    Screen ID Req ID Screen Name Comment
    DEF 2 Test 5
    HIJ 1 Test 6

    Requirements Tab: (desired result)
    Requirement ID Requirement Name Mapped Application Screen IDs Comment
    1 Req1 123,456,789,HIJ
    2 Req2 ABC,DEF

  2. #2
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    It would be better to attach an example workbook.
    Hope that helps

    Roy

  3. #3

    Attached workbook

    Quote Originally Posted by royUK View Post
    It would be better to attach an example workbook.
    Hi Roy
    The workbook is attached. As you can see in the "Worker Portal - Economic Stabil"(for example) column K could have more than one ID. Hence looking up the ID's from the "RFP Crosswalk"tab, i need to populate column L in the "RFP Crosswalk" to depict where each "RFP Req ID" from the "RFP Crosswalk" sheet occurs in the other tabs

  4. #4
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    Where is it attached?
    Hope that helps

    Roy

Posting Permissions

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