Yes, it is possible to use red wine vinegar to make cooking sherry. You can substitute an equal amount of red wine vinegar for a recipe that calls for cooking sherry. It will impart a subtle acidity and sweetness to the dish.