+ Reply to Thread
Results 1 to 3 of 3

Cell reference issue

  1. #1
    Registered User
    Join Date
    03-17-2009
    Location
    Denmark
    MS-Off Ver
    Excel 2003
    Posts
    2

    Cell reference issue

    Hi,

    I'm in the midst of make a worksheet and have now come to a problem which I have no idea of how to fix.

    The problem is that I would like a cell value dependent on a specifik number I write in a nother cell.

    Eksampel:

    the data consists of 4 different values 30 32 34 38 which is an upgrade from start value 30 (upgrade 0) to 32 (upgrade 1, +2) and so on.

    I would like to be able to write the number 0-3 in a cell called fx upgrade level, and then have the data from the cells where the upgrade data is (30 32...) and have those values put in a third cell.

    The point is that the upgrade levels change over time but I have alle the data for the upgrade values for each level, so it would be nice if I could just write the numbers 0-3 in a cell and have the new upgrade value in the third cell.

    Hope you understand what I'm getting at

    Cheers and thanks!

  2. #2
    Forum Contributor mubashir aziz's Avatar
    Join Date
    03-18-2009
    Location
    Lahore, Pakistan
    MS-Off Ver
    MS Office 2013
    Posts
    533

    Re: Cell reference issue

    I think your problem can be solved thru data validation but your question is still confusing. I can help if you attached your xls file and show your desired result manually in 3rd cell.

  3. #3
    Registered User
    Join Date
    03-17-2009
    Location
    Denmark
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Cell reference issue

    What I would like to do is to be able to write a number from 0-3, shown in green and have the corresponding value, shown i red to be written i the cells shown with blue.

    The point is to be able to change the green numbers ranging between 0-3 and have the corresponding red number moved to the celles with blue.

    In the xls file I've just put some 0-3 numbers in so you can see what I aiming at. The blue values are from the red values.

    hope it makes more sense now

    PS: it's in worksheet named DATA
    Attached Files Attached Files
    Last edited by ShinigamiDK; 03-18-2009 at 01:30 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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