Forum Discussion
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...
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.
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.
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.
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)- Perfect. Thank you!
