Hi

Try first to divide first column to types and categories
Like: HD 2A or PHD 2

then if you are familiar with vba algorythm should lokk like this(IMHO)-
input numer
Loop through first column,whenever type changes start the loop again for
new type,(HH,PHD,MSTC) compare results with third column

here I didnt understand either you mean nearest number or your examples
are not quite right.

so you compare with third column whenever the difference is smallest you
save in matrix

and then output it

by the way you could to it easier I think. again categorize them by HD
PHD and so on . make a pivot table based on this table. And use
criterias to filter and see data you want. (or simple auto macro)

*** Sent via Developersdex http://www.developersdex.com ***