+ Reply to Thread
Results 1 to 7 of 7

Formula to Enter Data from one sheet to another if cell contains certain text

  1. #1
    Registered User
    Join Date
    01-13-2014
    Location
    Delaware
    MS-Off Ver
    Excel 2010
    Posts
    4

    Formula to Enter Data from one sheet to another if cell contains certain text

    I am trying to set up a budget worksheet and I want to enter amount of an Item on another worksheet if it contains certain text in different column. This is what it looks like:
    (Sheet1) Cell E3:Mac Laptop
    (Sheet1) Cell H3:$1600
    (Sheet2) Want to enter the amount of the item if Laptop is in the Cell. So basically search Cell E3 on sheet1 for "Laptop" if true then enter data from Cell H3 from sheet1. This needs to be done for whole columns of E and H. So if we search anything in E then if true will return value from corresponding row in column H. Thanks

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Formula to Enter Data from one sheet to another if cell contains certain text

    Can you post a sample data set? I cant follow what you are trying to accomplish.

    Show me the data source and at least mock up the way you would LIKE the final tab (what you are calling Sheet2) to be.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    01-13-2014
    Location
    Delaware
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Formula to Enter Data from one sheet to another if cell contains certain text

    I have attached an example. Thanks
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-13-2014
    Location
    Delaware
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Formula to Enter Data from one sheet to another if cell contains certain text

    I attached the example to the thread. Thanks for your help

  5. #5
    Registered User
    Join Date
    01-12-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Formula to Enter Data from one sheet to another if cell contains certain text

    use following formulae
    =SUMIF(Sheet1!B3:B4,"*laptop*",Sheet1!E3:E4)
    =COUNTIF(Sheet1!B3:B4,"*laptop*")

    "ref as per your sample file.

  6. #6
    Registered User
    Join Date
    01-13-2014
    Location
    Delaware
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Formula to Enter Data from one sheet to another if cell contains certain text

    That worked great!! Thanks
    One more question. If I have a budgeted Quantity set for Laptops of 10, and we purchase 11, how do I make the amount from the 11th automatically go into another column titled "Unbudgeted"? Is that possible?

  7. #7
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Formula to Enter Data from one sheet to another if cell contains certain text

    =SUMIF(Sheet1!B:B,"*laptop*",Sheet1!E:E)
    =COUNTIF(Sheet1!B:B,"*laptop*")

+ 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] Enter formula only if a cell does not contain specific text
    By lday75 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-24-2013, 01:45 PM
  2. Replies: 3
    Last Post: 09-20-2013, 04:24 PM
  3. Enter different data into a cell and have it create a log on another sheet
    By lo0 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2012, 03:04 PM
  4. Enter text value into a empty cell using a vlookup from data on another sheet
    By Woodchuck75 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2012, 08:22 PM
  5. Formula to enter TEXT based on another cell
    By Petitboeuf in forum Excel General
    Replies: 2
    Last Post: 05-19-2005, 06:10 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