+ Reply to Thread
Results 1 to 2 of 2

Return values from a list to different cells in a column?

  1. #1
    Registered User
    Join Date
    09-24-2014
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    13

    Question Return values from a list to different cells in a column?

    Hello all,

    I am working on a database, where I need a formula to return all the report numbers to the corresponding "department".

    See attached excel workbook.

    The cells D3:F3 & D4:F4 & D5:F5 should return the 9 report numbers from column K:K.

    Can anyone assist me?
    Attached Files Attached Files

  2. #2
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,543

    Re: Return values from a list to different cells in a column?

    Hi,

    In D3, array formula**:

    =INDEX($K:$K,SMALL(IF($J$9:$J$17=$C3,ROW($J$9:$J$17)),COLUMNS($A:A)))

    Copy to the right and down.

    Regards


    **Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

+ 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: 4
    Last Post: 10-01-2015, 11:01 AM
  2. Replies: 2
    Last Post: 09-12-2015, 11:02 AM
  3. Replies: 5
    Last Post: 03-25-2015, 05:30 PM
  4. Macro that searches column B in all sheets for all the different values and return in list
    By pasqualebaldi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-29-2014, 02:43 PM
  5. Return list of cells in Col 3 that match both values in Col1 and 2
    By Malkier in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-17-2014, 02:18 AM
  6. [SOLVED] ID first and last non blank values in a row and return that cells column header
    By hotelmrrsn in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-13-2014, 02:35 PM
  7. Replies: 1
    Last Post: 07-03-2013, 12:14 AM

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