+ Reply to Thread
Results 1 to 8 of 8

Return list of Multiple Value from differents Cells in the same Column

  1. #1
    Registered User
    Join Date
    11-05-2018
    Location
    us
    MS-Off Ver
    365
    Posts
    4

    Return list of Multiple Value from differents Cells in the same Column

    Hi, Everyone.

    i've been looking a formulo for so long but found nothing, i really appreciate your help.

    i'm trying to make a lists indexing a column that contain labor numbers and each labor contain multiple Materials, the formula work for the first Labor Selected but no continue to the next cell

    The array formula is

    {=IFERROR(INDEX($A$2:$B$19,SMALL(IF($A$2:$B$19=$I$2,ROW($A$2:$B$19)-1),ROW(A1)),2),"")}

    thanks to every

    sorry if this was solved on another Thread.... i make some search but not found.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    5,060

    Re: Return list of Multiple Value from differents Cells in the same Column

    Your error was this:

    $A$2:$B$19=$I$2

    Checking two columns instead of one...


    Array-Enter this instead:

    =IFERROR(INDEX($B:$B,SMALL(IF($A$2:$A$19=$I$2,ROW($A$2:$A$19)),ROW(A1))),"")
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    11-05-2018
    Location
    us
    MS-Off Ver
    365
    Posts
    4

    Re: Return list of Multiple Value from differents Cells in the same Column

    Thanks is really a better formula... will replace for sure...

    but the big issue is about continue to next Cell $A$2:$B$19=$I$3 and then the other $A$2:$B$19=$I$4 to make a list of all materials needed...

  4. #4
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    5,060

    Re: Return list of Multiple Value from differents Cells in the same Column

    The next formulas should also only check one column:

    $A$2:$A$19=$I$3

    and then the other


    $A$2:$A$19=$I$4

  5. #5
    Registered User
    Join Date
    11-05-2018
    Location
    us
    MS-Off Ver
    365
    Posts
    4

    Re: Return list of Multiple Value from differents Cells in the same Column

    this can be automatic with a formula???
    this table is a simple sheet (created to request this help) from a workbook and the formula make references to others sheets with a lot of data and will be used by various employes.

    the column I from I2 to I6 will be constantly changing.

    is there a way to make the formula to look From I2 to I6 and return all value for each labor selected in this column

    thanks again and sorry to bother you

  6. #6
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    5,060

    Re: Return list of Multiple Value from differents Cells in the same Column

    Try this file....

  7. #7
    Registered User
    Join Date
    11-05-2018
    Location
    us
    MS-Off Ver
    365
    Posts
    4

    Re: Return list of Multiple Value from differents Cells in the same Column

    great!!!!! Cheers!!! very helpfull...

    a lot of work to do just to adjust it to my 74 cells on my workbook...

    thanks!!!

  8. #8
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    5,060

    Re: Return list of Multiple Value from differents Cells in the same Column

    What do you mean 74 cells? In column A/B? Just use Find/replace find 19 and replace with 74 or 1000 or....

    If you change your output, then you can use far simpler formulas:
    Last edited by Bernie Deitrick; 11-05-2018 at 05:46 PM.

+ 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. Return values from a list to different cells in a column?
    By NKJAER in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-09-2016, 03:43 AM
  2. [SOLVED] Formula to return the lowest value in differents tables
    By Keldion in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-10-2016, 06:40 PM
  3. [SOLVED] Differents dates in differents sheets
    By luizmachado in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2016, 12:57 PM
  4. [SOLVED] Return multiple non-adjacent cells based on drop down list
    By KBRogers1 in forum Excel General
    Replies: 4
    Last Post: 11-13-2014, 05:27 PM
  5. Drop Down List to return multiple results in multiple cells
    By Joshua27 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2014, 11:50 AM
  6. [SOLVED] return multiple results from one column based on cells in another column
    By chollyfunk in forum Excel General
    Replies: 5
    Last Post: 05-09-2012, 05:20 AM
  7. Replies: 1
    Last Post: 01-31-2012, 06:12 PM

Tags for this Thread

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