J
jmj713
Is it possible to have Excel automatically fill cells with certain data in
one column based on data in another column?
one column based on data in another column?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
RagDyer
Sure!
In B1 enter:
=(A1=1)*100
So if A1 contains 1, B1 will equate to 100.
That answers your question ... BUT ... I'll bet that's not what you're
looking for.
How about being more specific with your question.
In B1 enter:
=(A1=1)*100
So if A1 contains 1, B1 will equate to 100.
That answers your question ... BUT ... I'll bet that's not what you're
looking for.
How about being more specific with your question.
J
jmj713
How about being more specific with your question.
Surely. What I have is either "Shift 1" or "Shift 2" in Column D. I need a
formula that will automatically enter into Column I either "2:00" or "7:00"
respectively.
Surely. What I have is either "Shift 1" or "Shift 2" in Column D. I need a
formula that will automatically enter into Column I either "2:00" or "7:00"
respectively.
R
RagDyer
Try this in I1, and copy down as needed:
=LOOKUP(D1,{0,"Shift 1","Shift 2";"","2:00","7:00"})
=LOOKUP(D1,{0,"Shift 1","Shift 2";"","2:00","7:00"})
B
BM
I would say you could do this with an if statement,
=if(a1= "Shift 1","2:00",if(a1="Shift 2", "7:00")," ")
I don't have excel with me but I am pretty sure this would work.
RagDyer/All, do you think this is a bit sloppy?
=if(a1= "Shift 1","2:00",if(a1="Shift 2", "7:00")," ")
I don't have excel with me but I am pretty sure this would work.
RagDyer/All, do you think this is a bit sloppy?
J
jmj713
Try this in I1, and copy down as needed:
That works perfectly! Thanks so much.
=LOOKUP(D1,{0,"Shift 1","Shift 2";"","2:00","7:00"})
That works perfectly! Thanks so much.