How to omit Cell value if Value>Choice

[monskaye]

Hello guys I need a little bit help.
I am constructing a program where I can make economical cuts from bars given following:

length required
commercial size

Now Given L>Size, need tip how to choose Required size
L=Size or Omit choices Size<L

Thanks!

[Bosco]

Try,

In J14, copied down :

=INDEX(C$13:G$13,MATCH(1,INDEX(0+({1,2,3,4,5}*(C13:G13=I13)>0),0),0))

Regards
Bosco

[Bo_Ry]

Please try

J14 drag down

=LOOKUP(2,1/(C14:G14=I14),C$13:G$13)

or

=INDEX($C$13:$G$13,MATCH(AGGREGATE(15,6,ABS($C$13:$G$13/(C14:G14=I14)-B14),1),INDEX(ABS($C$13:$G$13/(C14:G14=I14)-B14),),))

[monskaye]

Thank you very much!