I just found this awesome list of ingredient substitutions. I was looking for a substitute for sherry...and found this great resource! If you're missing an ingredient...check this out! It might help!
amaretto: use ½ tsp almond extract in water for every ¼ cup called for
brandy: use in fruit juice in equal amounts called for;
cognac: peach, pear, or apricot juice in equal amounts called for;
red wine: cranberry juice, grape juice, tomato juice, even beef or vegetable broth can be used; sherry: apple, pineapple, and orange juices all make good sherry substitutions.