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

[totalBS]

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.

 

[NeonRedSharpie]

=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]

=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!

 

[Aladin Akyurek]

Would you repost your exhibits using one of these Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste for the images cannot be read into Excel cells?