+ Reply to Thread
Results 1 to 2 of 2

Issues with populating cells dependent on other inputs.

  1. #1
    Registered User
    Join Date
    01-11-2010
    Location
    Glasgow
    MS-Off Ver
    Excel 2002
    Posts
    15

    Question Issues with populating cells dependent on other inputs.

    I am attempting to populate a cell automatically depending on the input of another cell.

    Say for example Cell A1 = 1, then cell A2 would automatically = 100,

    I have set up a reference table on another sheet with the initial values (e.g. A1) and required reference (e.g. 100) in a table form,

    Can you direct me in the right direction in order to set this up?

    Thanks,

    Charlie

  2. #2
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    Re: Issues with populating cells dependent on other inputs.

    If it is simple that A2 = A1 * 100 then this formula will do:

    = $A$1 * 100 in Cell A2

    For reference tables use MATCH and INDEX

    In Cell A2: =INDEX(Sheet2!$A$1:$B$5, MATCH(Sheet1!$A$1,Sheet2!$A$1:$A$5,0),2)

    Where the table is in Sheet2 A1:B5
    Last edited by rwgrietveld; 01-11-2010 at 09:16 AM.
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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