Overhauling mismatched cell reference methods