John,
If it is a small repair, you may want to test out a product at Lowes. Homax ceiling texture. I'd suggest trying it on a scrap piece of drywall (make sure it's at ceiling height for testing). ... read more
This is based entirely on the Manufactueres recommended installation techniques per the scope of work to be performed. Such as location, what your fastening to etc.