Thread: Relate from one worksheet to another

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

lupina@op.pl 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