Forum Discussion

AntonDagner's avatar
AntonDagner
Copper Contributor
Dec 10, 2021

Question about Excel

Hi Everyone!

 

I'm trying to do something I have never tried before.  Normally, I can figure most things out using online forums, but I'm not even sure how to phrase a search for this.  So, here it goes.

 

I have a list of people, each with 5 options associated with them.  Looks sort of like this (slashes indicated separation of colums):

Person 1/Option 1/Option 2/Option 3/Option 4/Option 5/Column 6/Column 7

Person 2/Option 1/Option 2/Option 3/Option 4/Option 5/Column 6/Column 7

And so on.  What I want to do is create another column (this would be Column 6) where I can type in Option 1 or Option 3 or whatever option I choose and have the cell in Column 7 extract the data that correlates.  

 

Anyone know of a way to do this?  

 

Please let me know if it doesn't make any sense.


Thank you!

Anton Dagner

  • AntonDagner 

    It will return the value based on your choice in column J (considering numbers 1 to 5) as per your example;

     

     

    =INDEX(E3:I3,1,J3)

     

     

     

  • Can you please format some excel example?
    The way you mentioned can confuses us.
    I'm sure it can help with some ideas I have in mind, but I would like your assistance on provide some sample of how the data is distributed.
    • AntonDagner's avatar
      AntonDagner
      Copper Contributor

      Juliano-Petrukio Thanks for replying.  Just joined this forum today and have no idea how this all works, but I replied to my original message.  Here is a screen shot of what I have set up.  What I am trying to do is put in the cells under the heading "Bonus Level" is a number from 1 through 5 and have it pull the amounts from the corresponding columns into the "Bonus Amount" field.  This way, I can change the Bonus Level numbers and have the Bonus Amounts auto populate.  

      • Juliano-Petrukio's avatar
        Juliano-Petrukio
        Bronze Contributor

        AntonDagner 

        It will return the value based on your choice in column J (considering numbers 1 to 5) as per your example;

         

         

        =INDEX(E3:I3,1,J3)

         

         

         

Resources