Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Data Entry
Is it possible to have Excel automatically fill cells with certain data in
one column based on data in another column? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Data Entry
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. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "jmj713" wrote in message ... Is it possible to have Excel automatically fill cells with certain data in one column based on data in another column? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Data Entry
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Data Entry
Try this in I1, and copy down as needed:
=LOOKUP(D1,{0,"Shift 1","Shift 2";"","2:00","7:00"}) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "jmj713" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Data Entry
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? "RagDyer" wrote: Try this in I1, and copy down as needed: =LOOKUP(D1,{0,"Shift 1","Shift 2";"","2:00","7:00"}) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "jmj713" wrote in message ... 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Data Entry
Try this in I1, and copy down as needed:
=LOOKUP(D1,{0,"Shift 1","Shift 2";"","2:00","7:00"}) That works perfectly! Thanks so much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro question | Excel Worksheet Functions | |||
formula references change when data entry sheet is modified | Excel Worksheet Functions | |||
Complex data comparisson and entry problem | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Automatic Data Validation drop down creation | Excel Discussion (Misc queries) |