+ Reply to Thread
Results 1 to 2 of 2

need help with adding data into a cell automatically using the data from another cell

  1. #1
    Registered User
    Join Date
    10-14-2014
    Location
    Texas
    MS-Off Ver
    MS Office 2010
    Posts
    6

    need help with adding data into a cell automatically using the data from another cell

    I am creating a spreadsheet which will be used as a template for work requests that will be printed. I am wanting to make the process of entering information onto the sheet much easier.

    What I want to be able to do is add data onto one cell and have the next cell automatically populate with related data. For example, when I add an item number onto cell A1, cell B1 will then automatically populate with the description of the item number. The cell names being used is Item Number, Description, Total, and Unit of Measure. I am hoping to find a way that will automatically populate the Description and Unit of Measure cells according to Item Number. I hope this makes sense.

    Is this possible? I have no clue what this process is called, therefore, I have had a difficult time finding any tutorials or videos for this. Any help will be appreciated.

    Thanks!

  2. #2
    Registered User
    Join Date
    10-14-2014
    Location
    Texas
    MS-Off Ver
    MS Office 2010
    Posts
    6

    Re: need help with adding data into a cell automatically using the data from another cell

    I believe I have found the answer to this using VLOOKUP. By using a VLOOKUP formula, I am able to get the results I am looking for. If anyone else another way of doing this, please advise.

    Thanks!

+ 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: 7
    Last Post: 03-12-2013, 08:58 AM
  2. [SOLVED] Can I automatically data into one cell if I enter data in another cell?
    By Ozzmatron in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-06-2012, 09:28 AM
  3. Replies: 2
    Last Post: 01-30-2012, 06:53 AM
  4. Replies: 3
    Last Post: 08-18-2009, 09:46 PM
  5. Need To Input Data Automatically In One Cell Based On Data In Cell Next To It
    By beltman713 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2008, 10:19 PM

Tags for this Thread

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