Wayne_Sadler said:

I got to say I'm playing but

If seems to WORK

Many Many THANKS !!! for your help

I don't know what else to say, but MANY THANKS

Wayne

The formula

=IF(N(A1)<=300,LOOKUP(A1,{-9.99999999999999E+307,0,100,200},{"",10,18,25}),"")

references a built-in table.

You could put the values involved in A2:B5 on Sheet2 or on a sheet you could name Admin. Thus;

Put the values from {-9.99999999999999E+307,0,100,200} in A2:A5 and the values fom {"",10,18,25} in B2:B5, with one exception: B2 must house the following formula:

=""

instead of just "".

Now select A2:B5, go to the Name Box on the Formula Bar, type Table, and hit enter. The LOOKUP formula can then be modified to reference Table instead of a built-in table:

=IF(N(A1)<=300,LOOKUP(A1,Table),"")