Results 1 to 2 of 2

Need help associating (referencing a secondary cell) A1 to B1

Threaded View

  1. #1
    Registered User
    Join Date
    06-23-2009
    Location
    Milwaukee, WI
    MS-Off Ver
    Excel:Mac 2008
    Posts
    4

    Need help associating (referencing a secondary cell) A1 to B1

    I have a worksheet where I want a pulldown list, which I can do easily, however, in the reference cells for the pulldown list I have a column of data next to it that I want to show up in the cell next to the pull down list when a cell is selected.

    To further explain this the worksheet is an amperage calculator, I work for a lighting company. I want to have a reference sheet as such, Where the first column is the fixture type and the second column is the wattage associated with that fixture
    A1: FIXTURE1 B2:2000
    A2: FIXTURE2 B2:2500
    A3: FIXTURE3 B2:1800
    A4: FIXTURE4 B2:1000

    On the actual load calculation part of this sheet the pull down list will be the range A1:A4, and in another cell I want it to automatically input the wattage for that row.

    How can I do this? Any ideas, I really need to get this to work soon!
    Last edited by mliptack; 06-23-2009 at 11:36 AM.

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