From: Puzzled on 5 Jun 2010 17:32 Your amazing on this stuff. Thanks so much "Puzzled" wrote: > > 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. > > >> > > >> > > >> . > > >> > > > > > > . > > Your
From: Bob Phillips on 6 Jun 2010 06:15 Try =IF(ISNUMBER(MATCH(A2,Sheet2!A1:P1,0)),INDEX(Sheet2!A2:P2,1,MATCH(A2,Sheet2!A1:P1,0)),"") -- HTH Bob "Puzzled" <Puzzled(a)discussions.microsoft.com> wrote in message news:8AA3B92F-5306-4889-989E-C9BFAEFA530D(a)microsoft.com... > > 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. >> >> >> >> >> >> . >> >> >> >> >> . >>
First
|
Prev
|
Pages: 1 2 Prev: How many cells can a correlation function cover? Next: can't "undo" to original document |