# Excel Problem

#### vivienne3608

##### New Member
Good morning,

I am hoping someone can help me. I need the formula to try and pick the closest greater proposed value to the current value and the previous formula I had worked =MIN(IF(A2:A15=H2,IF(B1:E1=H3,IF(B2:E15>=H4,B2:E15)))). However I have now noticed that in my larger data table (the table displayed is just a snapshot) the current value could be higher than the largest value for the proposed value options. I therefore need the formula to do as the above formula but to also pick the highest proposed value for that particular group and stage if there is no higher option than the current value. The following formula returns a zero figure:</SPAN></SPAN>

=MIN(IF(\$A\$2:\$A\$15=H2,IF(INDEX(\$B\$2:\$E\$15,0,MATCH(H3,\$B\$1:\$E\$1,0))>=H4,</SPAN></SPAN>
INDEX(\$B\$2:\$E\$15,0,MATCH(H3,\$B\$1:\$E\$1,0)))))</SPAN></SPAN>

The table below shows the higher current value and the proposed amount I need the formula to return. I know the proposed value I need appears twice, however, it doesn’t matter which cell the formula picks. The cells B2:E15 contain the proposed amounts. (</SPAN></SPAN>The proposed amount should be equal or higher than the current amount. However there are a few instances when the current amount is higher than the largest proposed option. In that case I want excel to pick that largest proposed option even if it is not equal or greater than the current amount).</SPAN>

 A B C D E F G H 1 1 2 3 4 2 Top 37,930 39,830 41,830 44,130 Group Bottom 3 Top 37,930 39,830 41,830 44,130 Stage 1 4 Top 37,245 39,145 41,045 43,345 Current Amount 34,719 5 Top 36,459 38,359 40,259 42,559 Proposed Amount 33,334 6 Top 35,774 37,574 39,374 41,674 7 Top 34,988 36,688 38,488 40,688 8 Top 34,988 36,688 38,488 40,688 9 Bottom 33,334 34,834 36,534 38,634 10 Bottom 33,334 34,834 36,534 38,634 11 Bottom 32,758 34,158 35,758 37,858 12 Bottom 32,182 33,582 35,082 37,182 13 Bottom 31,507 32,807 34,007 35,907 14 Bottom 30,931 32,031 33,131 34,731 15 Bottom 30,931 32,031 33,131 34,731

<TBODY>
</TBODY>

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

#### vivienne3608

##### New Member
Hello,

I no longer need any further replies to this issue. Thank you to all who have taken the time to try and find a solution for me I appreciate it.

Vivienne​

Replies
23
Views
3K

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,598
Messages
5,832,645
Members
430,150
Latest member
amitk1

### 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