Thanks. That really seems to work fine. One refinement though: is it
possible to use cell references instead of the 1.5, 2.7 series of numbers? I
can't seem to get that working, and it would solve all of my problems at
once!

Thanks again

Clive


On 10/4/06 10:25, in article , "Bob
Phillips" wrote:

=VLOOKUP(A1,{1,1.5;2,2.7;3,2.9;4,3.1;5,3.5;6,3.8;7 ,4.1;8,5.2;9,6.3;10,7.3},2
,FALSE)

or put the values in a table and refer to that.