I'm trying to make a formula for a list to check and strike out another on 3 sheets. Only 2 are using the info, sheet 3 has various colums to check. Sheet 2 A B dog yes cat (blank) Sheet 3 A C E etc... Dog(striked) Blank Dog(striked) If sheet 2, B is yes then check Sheet 3 colums and strike them out. Hope that made sense. Similar to a called off list. Please help me if you can. TIA Ginger
Try posting your question in an Excel-specific newsgroup. -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Ginger" <Ginger@discussions.microsoft.com> wrote in message news:7705FF7E-4EE0-47F4-AF30-F1F24FE9626F@microsoft.com... > I'm trying to make a formula for a list to check and strike out another on > 3 > sheets. Only 2 are using the info, sheet 3 has various colums to check. > > Sheet 2 > A B > dog yes > cat (blank) > > Sheet 3 > A C E etc... > Dog(striked) Blank Dog(striked) > If sheet 2, B is yes then check Sheet 3 colums and strike them out. Hope > that made sense. Similar to a called off list. > > Please help me if you can. > TIA > Ginger > > > >