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