You can save yourself a lot of manual editing, or even copying and pasting, in Excel by using the search and replace (Ctrl-h) feature. This will replace all occurrences of one value, or even a part of a formula, with a different value.
Say you defined a lookup range improperly, setting the rightmost column to H, […]

continue reading.....