Formula Questions
in [General]
|
From: Puzzled on 5 Jun 2010 10:40 Having trouble with formulas. I have two work sheets. Work sheet1 is a work order. Work sheet2 is what needs to be done by a certain date. What I need to do is type in a date in work sheet 1. At that point the date has to find the date on work sheet2. Once the date is found the formula needs to check if anything is in b2 in work sheet2, and if it is, move what is in a2 into work sheet 1. Highly confused. I have never attempted this before. Any help would be highly appreciated.
From: Bob Phillips on 5 Jun 2010 11:47 Try =IF(ISNUMBER(MATCH(A2,Sheet2!A:A,0)),IF(Sheet2!B2<>"",Sheet2!A2,""),"") -- HTH Bob "Puzzled" <Puzzled(a)discussions.microsoft.com> wrote in message news:96A2BE78-CC2E-42B0-A5A4-43DCD9C2A987(a)microsoft.com... > Having trouble with formulas. I have two work sheets. Work sheet1 is a > work > order. Work sheet2 is what needs to be done by a certain date. What I need > to > do is type in a date in work sheet 1. At that point the date has to find > the > date on work sheet2. Once the date is found the formula needs to check if > anything is in b2 in work sheet2, and if it is, move what is in a2 into > work > sheet 1. Highly confused. I have never attempted this before. Any help > would > be highly appreciated.
From: Puzzled on 5 Jun 2010 13:16 Thanks Bob, this was very helpful. Is there a way to tell it to check from a1 to p1 for the date, than move the information if the date is found in any of those blocks. EX: If the date if found in m1 on sheet2 then move what is in m2 to sheet1 Thanks Again Bob "Bob Phillips" wrote: > Try > > =IF(ISNUMBER(MATCH(A2,Sheet2!A:A,0)),IF(Sheet2!B2<>"",Sheet2!A2,""),"") > > -- > > HTH > > Bob > > "Puzzled" <Puzzled(a)discussions.microsoft.com> wrote in message > news:96A2BE78-CC2E-42B0-A5A4-43DCD9C2A987(a)microsoft.com... > > Having trouble with formulas. I have two work sheets. Work sheet1 is a > > work > > order. Work sheet2 is what needs to be done by a certain date. What I need > > to > > do is type in a date in work sheet 1. At that point the date has to find > > the > > date on work sheet2. Once the date is found the formula needs to check if > > anything is in b2 in work sheet2, and if it is, move what is in a2 into > > work > > sheet 1. Highly confused. I have never attempted this before. Any help > > would > > be highly appreciated. > > > . >
From: Bob Phillips on 5 Jun 2010 13:30 When you find a value in A1:P1, do you want to check the corresponding value in B2:Q2 for a value, and then move in the value from A2:P2, is that what you are asking? -- HTH Bob "Puzzled" <Puzzled(a)discussions.microsoft.com> wrote in message news:724EF586-B1D7-41D8-B7EA-1FE4CE73CC81(a)microsoft.com... > Thanks Bob, this was very helpful. Is there a way to tell it to check from > a1 > to p1 for the date, than move the information if the date is found in any > of > those blocks. > > EX: If the date if found in m1 on sheet2 then move what is in m2 to sheet1 > > Thanks Again Bob > > > "Bob Phillips" wrote: > >> Try >> >> =IF(ISNUMBER(MATCH(A2,Sheet2!A:A,0)),IF(Sheet2!B2<>"",Sheet2!A2,""),"") >> >> -- >> >> HTH >> >> Bob >> >> "Puzzled" <Puzzled(a)discussions.microsoft.com> wrote in message >> news:96A2BE78-CC2E-42B0-A5A4-43DCD9C2A987(a)microsoft.com... >> > Having trouble with formulas. I have two work sheets. Work sheet1 is a >> > work >> > order. Work sheet2 is what needs to be done by a certain date. What I >> > need >> > to >> > do is type in a date in work sheet 1. At that point the date has to >> > find >> > the >> > date on work sheet2. Once the date is found the formula needs to check >> > if >> > anything is in b2 in work sheet2, and if it is, move what is in a2 into >> > work >> > sheet 1. Highly confused. I have never attempted this before. Any help >> > would >> > be highly appreciated. >> >> >> . >>
From: Puzzled on 5 Jun 2010 15:49 I need the formula to check the columns from a1 thru p1. Only one will have the correct date in it. Once the date is found, than move the corresponding B value to the other sheet. EX: If the date was found in M1 then the value in M2 would move to the other sheet. "Bob Phillips" wrote: > When you find a value in A1:P1, do you want to check the corresponding value > in B2:Q2 for a value, and then move in the value from A2:P2, is that what > you are asking? > > -- > > HTH > > Bob > > "Puzzled" <Puzzled(a)discussions.microsoft.com> wrote in message > news:724EF586-B1D7-41D8-B7EA-1FE4CE73CC81(a)microsoft.com... > > Thanks Bob, this was very helpful. Is there a way to tell it to check from > > a1 > > to p1 for the date, than move the information if the date is found in any > > of > > those blocks. > > > > EX: If the date if found in m1 on sheet2 then move what is in m2 to sheet1 > > > > Thanks Again Bob > > > > > > "Bob Phillips" wrote: > > > >> Try > >> > >> =IF(ISNUMBER(MATCH(A2,Sheet2!A:A,0)),IF(Sheet2!B2<>"",Sheet2!A2,""),"") > >> > >> -- > >> > >> HTH > >> > >> Bob > >> > >> "Puzzled" <Puzzled(a)discussions.microsoft.com> wrote in message > >> news:96A2BE78-CC2E-42B0-A5A4-43DCD9C2A987(a)microsoft.com... > >> > Having trouble with formulas. I have two work sheets. Work sheet1 is a > >> > work > >> > order. Work sheet2 is what needs to be done by a certain date. What I > >> > need > >> > to > >> > do is type in a date in work sheet 1. At that point the date has to > >> > find > >> > the > >> > date on work sheet2. Once the date is found the formula needs to check > >> > if > >> > anything is in b2 in work sheet2, and if it is, move what is in a2 into > >> > work > >> > sheet 1. Highly confused. I have never attempted this before. Any help > >> > would > >> > be highly appreciated. > >> > >> > >> . > >> > > > . >
|
Next
|
Last
Pages: 1 2 Prev: How many cells can a correlation function cover? Next: can't "undo" to original document |