+ Reply to Thread
Results 1 to 2 of 2

Populating cells with data that matches certain criteria

  1. 06-17-2013, 10:04 PM #1
    coach.32
    coach.32 is offline
    Forum Contributor
    Join Date
    11-20-2009
    Location
    Melbourne
    MS-Off Ver
    Excel 365
    Posts
    260

    Populating cells with data that matches certain criteria

    As per sample attached, I was wondering how can I populate my Sheet1!LB1's column with the names from Sheet2 who have LB1 in the date column. (ie: Find the rows with LB1 in Sheet 2 Date Column and paste the corresponding names in Sheet1 Column A)
    I have placed the names that should be in the column as an example of the result I am looking for.
    The proper spreadsheet has a list a lot longer than the 4 names in the sample.
    I know I could filter and copy the visible cells but I am hoping there is a formula that will give me the desired result.
    Thank you for any assistance you may be able to give me.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-17-2013, 10:13 PM #2
    benishiryo
    benishiryo is offline
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Populating cells with data that matches certain criteria

    hi there again. try this array formula in Sheet1!A2:
    =IFERROR(INDEX(Sheet2!A:A,SMALL(IF(Sheet2!$C$2:$C$10="LB1",ROW(Sheet2!$C$2:$C$10)),ROWS(A$2:A2))),"")
    ...confirmed by pressing CTRL-SHIFT-ENTER to activate the array. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL-SHIFT-ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."

    Tips & Tutorials I Compiled | How to Get Quick & Good Answers
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1