I have this formula, I am running into an issue when I want the nth value, but it matches the nth value for another column, then does a match to get what value in this column.
Visual is below. Column B matches the index of Column C to return a value based on the value. I want it to show what the actual value will be.
A B C
Visual is below. Column B matches the index of Column C to return a value based on the value. I want it to show what the actual value will be.
A B C
1 | APPLE | 20% |
2 | ORANGE | 33% |
3 | PINEAPPLE | 40% |
4 | PINEAPPLE | 40% |
5 | PINEAPPLE | 40% |