# Find next highest value in table and output the cell next to it

#### totalBS

##### New Member
I have a table with two columns, the first column is what I want to output and the second column contains areas that I want to find a greater value compared to my input. What I am trying to do is obtain an area by dividing one cell by another, and using this area I want to look into my table, find an area that is greater than what I just calculated, and then output the cell next to this greater area. VLOOKUP is not going to work and I can't seem to get INDEX MATCH to work. My formula is =INDEX(L5:M12,MATCH(I5/C5,M5:M12,-1),1) and I included a snapshot below. I want this formula to return "#6" since the area I want to be greater than is 2.88/8=0.36. I would prefer it to not require additional helper columns with intermediate steps that I hide.

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

#### NeonRedSharpie

##### Well-known Member
Code:
``=INDEX(L5:L12,MATCH(I5/C5,M5:M12,1)+1)``

Here's a hack. I don't know why the -1 isn't working because your code should work.

#### totalBS

##### New Member
Code:
``=INDEX(L5:L12,MATCH(I5/C5,M5:M12,1)+1)``

Here's a hack. I don't know why the -1 isn't working because your code should work.

I thought the code would have worked too but your hack did it. Thank you!

Replies
7
Views
433
Replies
6
Views
249
Replies
7
Views
464
Replies
5
Views
452
Replies
36
Views
2K

1,195,659
Messages
6,010,956
Members
441,578
Latest member
brodiej

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back