formula to match next value if value is in row above.

[Godwin117]

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

1	APPLE	20%
2	ORANGE	33%
3	PINEAPPLE	40%
4	PINEAPPLE	40%
5	PINEAPPLE	40%

 

[Godwin117]

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

1	APPLE	20%
2	ORANGE	33%
3	PINEAPPLE	40%
4	PINEAPPLE	40%
5	PINEAPPLE	40%

The formula is =INDEX($F$6:$K$196,MATCH($AJ9,$I$6:$I$196,0),1)