Question about Excel

[AntonDagner]

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

[#2]

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.

[#3]

@AntonDagner 

Here is an example of what I'm trying to do:

[#4]

@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.  

[#5 · Accepted solution]

@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)

[#6]

Perfect. Thank you!