Relate from one worksheet to another

G

Guest

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
 
A

Aladin Akyurek

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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the right style field in VBA 0
Write formula for simple copy and paste to another cell 1
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Extracting Data from another worksheet based on user input 14
Multiply with Vlookup value from another Worksheet 0
Changing relative cell reference 2
Need multiple IF questions & return a value from another worksheet 6
Blank cell from another page within a worksheet? 9

Top