Thread: Random search
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
roy.okinawa
 
Posts: n/a
Default Random search

If column K3 is filled (date) and/or column AC3 if filled (date), I want the
text in column X3 to autopopulate in column AE3 as long as in matches the
mm/yyyy that I have entered in AE1.

Column X will always keep its data. Column AE can changed based on the date
entered in AE1.


AE1

12/2005

K3 X3 AC3
AE3
12/15/2005 Unrepairable 12/20/2005
Unrepairable
12/16/2005 Serviceable 12/21/2005
Serviceable