That is no different from any other formulas except if you use INDIRECT in a
special way
VLOOKUP behaves the same as SUMPRODUCT in this regard


--
Regards,

Peo Sjoblom
'

"Positive" wrote in message
ps.com...
On Jul 2, 2:47 pm, "Peo Sjoblom" wrote:
SUMPRODUCT is no different than any other functions in this regard,
you might want to give us an example where VLOOKUP using same references
as
SUMPRODUCT acted any differently

--
Regards,

Peo Sjoblom

"Positive" wrote in message

oups.com...



When I use SUMPRODUCT formula, especially to look up data from
different workbooks and return to a different workbook, I tend to
have
problem later on when I work on it or save it to a different file.
All
my other formulas e.g IF, VLOOK never been messed up when I work on
the file or save it to a different file.

Is there anyway I could protect this SUMPRODUCT formula or any reason
why it get messed up so easily?
Thanks

Positive- Hide quoted text -

- Show quoted text -

For example, I have a spreadsheet, when i insert a row, then all my
SUMPRUCT formulas get messed up