Identify your recipe use: pan sauce, braise, baking, or glaze—cream sherry is often used for sweetness + fortified depth.
Choose the closest substitute from the list by flavor: nuttiness + light sweetness first, then acidity support.
Use the stated ratio. If your substitute is less sweet (dry sherry), add sweetness gradually; if it’s sweeter (port), dilute slightly.
Simmer (sauce/braise) or bake briefly (if applicable) for 1–3 minutes so the flavors meld and you can correct seasoning.
Taste and adjust: add a pinch of sugar for lift, or a few drops of vinegar/lemon if it tastes too heavy or one-note.