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

Godwin117

New Member
Joined
Dec 19, 2019
Messages
42
Office Version
365, 2019
Platform
Windows
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

1APPLE20%
2ORANGE33%
3PINEAPPLE40%
4PINEAPPLE40%
5PINEAPPLE40%
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Godwin117

New Member
Joined
Dec 19, 2019
Messages
42
Office Version
365, 2019
Platform
Windows
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

1APPLE20%
2ORANGE33%
3PINEAPPLE40%
4PINEAPPLE40%
5PINEAPPLE40%

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

Watch MrExcel Video

Forum statistics

Threads
1,095,350
Messages
5,443,953
Members
405,258
Latest member
daveyf

This Week's Hot Topics

Top