+ Reply to Thread
Results 1 to 3 of 3

Populate specific cell?

  1. #1
    Registered User
    Join Date
    08-24-2007
    Posts
    52

    Populate specific cell?

    I am looking for some guidance on how to populate a specific matching cell.

    I have attached an example.

    In column A I have a start date and in Column B I have the hours. I am trying to get the hours to show up in the correct column that references the original start date Column A...

    Any help would be appreciated!

    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Populate specific cell?

    Unless I'm misunderstanding, in E2 copied to the right
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    01-31-2013
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    1,073

    Re: Populate specific cell?

    Hi -

    Copy and paste this formula into Cell E2 and copy across:

    =IFERROR(VLOOKUP(E1,$A$2:$C$5,3,0),"")

    Hope this helps.
    ____________________________________________
    If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
    -Go to the top of the first post
    -Select Thread Tools
    -Select Mark thread as Solved

    If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.

+ 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: 12-31-2018, 02:42 PM
  2. [SOLVED] Populate from a specific cell if it is a number?
    By kellyfirth in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-13-2015, 09:45 AM
  3. [SOLVED] Auto Populate Months from a specific cell
    By louflew in forum Excel General
    Replies: 3
    Last Post: 01-10-2014, 11:42 AM
  4. Replies: 1
    Last Post: 11-21-2013, 06:07 AM
  5. Having issue trying to get a specific value to populate in another cell
    By defilted in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-01-2013, 01:29 PM
  6. [SOLVED] auto populate cell data based on specific selection in another cell
    By tinka590 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2013, 02:37 AM
  7. Populate an offset cell with a specific value
    By joerob88 in forum Excel General
    Replies: 1
    Last Post: 10-10-2009, 10:34 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