Hello Everybody,

here is what I am trying to do, below you can see a table including some
names and numbers,
as you see on samples (below the table) ,I need to write a VBA that can give
me some names from the table base in the input data
as you also see,from each part of the table I need the first largest number
after the input number.
is it possible to do that ? can any one help me or direct me to make such
VBA ?

Thanks in advance



================================================== ===============

name number

HD2A |2775
HD5A |4010
HD6A |5105
HD8A |7460
HD10A |9540
HD14A |11080
HD20A |11090
HD15 |15305
=======
PHD2 |3610
PHD5 |4685
PHD6 |5860
PHD8 |6730
=======
MSTC28 |2760
MSTC40 |3985
MSTC52 |4740
MSTC66 |5855
=======
HD2 |585
HD5 |890
HD6 |735
=======


Sample-1:
INPUT: 2800 - result: HD2A,PHD2,MSTC28

SAMPLE-2:
INPUT : 8545 - RESULT: HD10A

SAMPLE-3:
INPUT : 6325 - RESULT: HD8A,PHD6

SAMPLE-4:
INPUT : 1500 - RESULT: HD2A,PHD2,MSTC28,HD2A

SAMPLE-5:
INPUT : 300 - N/A (NOTHING)

SAMPLE-6:
INPUT : 20000 - OVER LIMIT