A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Formula Questions



 
 
Thread Tools Display Modes
  #1  
Old June 5th, 2010, 03:40 PM posted to microsoft.public.excel.misc
puzzled
external usenet poster
 
Posts: 62
Default Formula Questions

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.
Ads
  #2  
Old June 5th, 2010, 04:47 PM posted to microsoft.public.excel.misc
Bob Phillips[_3_]
external usenet poster
 
Posts: 489
Default Formula Questions

Try

=IF(ISNUMBER(MATCH(A2,Sheet2!A:A,0)),IF(Sheet2!B2 "",Sheet2!A2,""),"")

--

HTH

Bob

"Puzzled" wrote in message
...
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.



  #3  
Old June 5th, 2010, 06:16 PM posted to microsoft.public.excel.misc
puzzled
external usenet poster
 
Posts: 62
Default Formula Questions

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" wrote in message
...
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.



.

  #4  
Old June 5th, 2010, 06:30 PM posted to microsoft.public.excel.misc
Bob Phillips[_3_]
external usenet poster
 
Posts: 489
Default Formula Questions

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" wrote in message
...
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" wrote in message
...
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.



.



  #5  
Old June 5th, 2010, 08:49 PM posted to microsoft.public.excel.misc
puzzled
external usenet poster
 
Posts: 62
Default Formula Questions


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" wrote in message
...
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" wrote in message
...
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.


.



.

  #6  
Old June 5th, 2010, 10:32 PM posted to microsoft.public.excel.misc
puzzled
external usenet poster
 
Posts: 62
Default Formula Questions

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" wrote in message
...
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" wrote in message
...
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

  #7  
Old June 6th, 2010, 11:15 AM posted to microsoft.public.excel.misc
Bob Phillips[_3_]
external usenet poster
 
Posts: 489
Default Formula Questions

Try

=IF(ISNUMBER(MATCH(A2,Sheet2!A1:P1,0)),INDEX(Sheet 2!A2:P2,1,MATCH(A2,Sheet2!A1:P1,0)),"")

--

HTH

Bob

"Puzzled" wrote in message
...

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" wrote in message
...
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" wrote in message
...
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.


.



.



  #8  
Old February 22nd, 2011, 12:45 PM
RichardBoomhowern RichardBoomhowern is offline
Banned
 
First recorded activity by OfficeFrustration: Feb 2011
Location: USA
Posts: 13
Send a message via ICQ to RichardBoomhowern
Default

I simply passed this onto a colleague who was doing a little analysis on that
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:35 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 OfficeFrustration.
The comments are property of their posters.