Hello,

Use LOOKUP:
=LOOKUP(A1,{0,10,50,100,200,...},{0.1,0.25,0.5,0.6 ,...})
You may want to write the vectors into ranges and let lookup refer to
those...

HTH,
Bernd