View Single Post
  #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.