excel 2003 formula

G

Ginger

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
 
Top