1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

excel 2003 formula

Discussion in 'Microsoft Office' started by Ginger, Apr 8, 2010.

  1. Ginger

    Ginger Flightless Bird

    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
     
  2. JoAnn Paules [MVP]

    JoAnn Paules [MVP] Flightless Bird

    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
    >
    >
    >
    >
     

Share This Page