Excel Solution needed

[prasanna200]

Dear Experts,

How to compare a number with set of numbers and select nearest higher value. After this it should allocate a model which is already defined.

Example:
Number 25 should be compared with 26,28,29,30,25.5.
Then it should select 25.5 as nearest higher value.
If 25<25.5 is true, then assign MOdel#10 to a cell with different address.

Please help me out to solve this problem.

Thanks in advance.

Prasanna A P

[zbor]

=lookup(d7+0,5;{24;24,5;25;25,5;26;26,5;27;27,5;28})

[mudraker]

prasanna200

Welcome to Exceltip forum

Please take a couple of minutes and read ALL the Forum Rules then edit your thread title by following the instructions in the rules (Rule 1) so that it better discribes your problem/request