Prev: How many cells can a correlation function cover?
Next: can't "undo" to original document
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