Welcome Guest
Log In | Register )
You last visited December 5, 2016, 9:28 am
All times shown are
Eastern Time (GMT-5:00)

need help with xl

Topic closed. 3 replies. Last post 6 years ago by phileight.

Page 1 of 1
PrintE-mailLink
Avatar
Mount Morris
United States
Member #46750
September 27, 2006
139 Posts
Offline
Posted: December 14, 2010, 5:05 pm - IP Logged

Would like to be able to type in one cell say A1 =2 

Then in a 2nd sheet I would have say  2=  96  30 in a  cell  to look for

  so when I type in themain sheet in A1 =  2  then in cell  b3 = 96   b4 =30

    Avatar

    United States
    Member #41846
    June 23, 2006
    459 Posts
    Online
    Posted: December 14, 2010, 6:54 pm - IP Logged

    Would like to be able to type in one cell say A1 =2 

    Then in a 2nd sheet I would have say  2=  96  30 in a  cell  to look for

      so when I type in themain sheet in A1 =  2  then in cell  b3 = 96   b4 =30

    Hillbilly953

    I don't understand what you want. some info must be missing

      Avatar
      Mount Morris
      United States
      Member #46750
      September 27, 2006
      139 Posts
      Offline
      Posted: December 14, 2010, 8:09 pm - IP Logged

      say I got 25 sets of pairs and each set of pairs have got a code for them like   9 = 65  or 32    or say   5 = 04  or  97    so what I want to do is be

      able to type the 9 in a cell and it would come up with the 65 in a cell  and 32 in another cell  I don't want the pairs and its code to be seen on the master sheet.

      i want the master sheet  cell A1  you would type in the 9  and it spits the 65   32  out in the cell b2  b4

        Avatar

        United States
        Member #41846
        June 23, 2006
        459 Posts
        Online
        Posted: December 18, 2010, 3:10 pm - IP Logged

        hillbilly953

        the indirect command would seem to be what you need.  I'm not real clear on what you want to do so help is limited.  you can google excel and indirect command to see examples of how to use it.