Hi everyone
I have two worksheets : A and B
Each of them have the same size, but each field of B is making from fields
of workseet A.

I'd like that eg. field (A1 ) in B checking filed (A1) in A and

if (A1) A < 0.37 then A1(B) = 0
if (A1) A = 0.37 and < 1.73 then A1(B) = 1
if (A1) A = 1.73 and < 5.2 then A1(B) = 3
if (A1) A = 5.2 then A1(B) = 9

Because I am very beginner and I don't use excel very often please give me
advice how to do it.
Thanks

wrote:
Hi everyone
I have two worksheets : A and B
Each of them have the same size, but each field of B is making from fields
of workseet A.

I'd like that eg. field (A1 ) in B checking filed (A1) in A and

=LOOKUP(A!A1,{-9.99999999999999E+307,0.37,1.73,5.2},{0,1,3,9})

if (A1) A < 0.37 then A1(B) = 0
if (A1) A = 0.37 and < 1.73 then A1(B) = 1
if (A1) A = 1.73 and < 5.2 then A1(B) = 3
if (A1) A = 5.2 then A1(B) = 9

Because I am very beginner and I don't use excel very often please give me
advice how to do it.
Thanks

Great Thanks,
it works perfectly :)