+ Reply to Thread
Results 1 to 2 of 2

Populate a cell based on another tab's information with a function

  1. #1
    Registered User
    Join Date
    07-04-2015
    Location
    Nevada
    MS-Off Ver
    MS OFFICE 365
    Posts
    43

    Populate a cell based on another tab's information with a function

    I would like to populate a cells with a date that that person is going to present the safety meeting by quarter. The tab is under Names, the information has to come from the 2018 tab. I have tried the IF function, and MATCH but I can't figure it out. I have attached my example spreadsheet. Each person has a number associated with their name, which I thought would make the formula easier to build, but it hasn't. If 1 (henry) has the date left of his name of 1/30/18 I want to put that in 1st Qtr next to henry in the Names tab.

    I hope this makes sense.

    Thank you.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Re: Populate a cell based on another tab's information with a function

    1.Create helper column I added it to Column F on the 2018 tab - =CONCATENATE($D2,ROUNDUP(MONTH($B2)/3,0))
    2. On the Names Tab under 1st Qtr add: =IFERROR(INDEX('2018'!$B:$F,MATCH($B2&"1",'2018'!$F:$F,0),1),"")
    The "1" is the quarter number - under second qtr add: =IFERROR(INDEX('2018'!$B:$F,MATCH($B2&"2",'2018'!$F:$F,0),1),"")

+ 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. [SOLVED] populate row information based on cell condition or cell value
    By opusarlo in forum Excel General
    Replies: 8
    Last Post: 11-02-2015, 11:22 AM
  2. Populate cells with specific information based on one cell
    By MrMims in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-13-2013, 02:25 PM
  3. Populate data based on cell information
    By famico78 in forum Excel General
    Replies: 6
    Last Post: 04-04-2013, 06:11 PM
  4. Replies: 1
    Last Post: 06-24-2012, 10:07 AM
  5. Populate row information based on start end dates
    By rdesai7677 in forum Excel General
    Replies: 6
    Last Post: 03-12-2012, 06:41 PM
  6. Replies: 2
    Last Post: 06-08-2011, 02:36 PM
  7. Replies: 2
    Last Post: 08-02-2010, 09:25 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