Forum Discussion
Solved
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)- In this case two intermediate function one for the row and another for the column. The row function is needed to get the index for the row and the match function is needed to get the index for the column; These are in addition to the index function already suggested. Pay attention that row is always changing going downward and the option selected would determine the column to horizontally lookup the bonus.
