I'm using an array formula, in which I refer to a named range of cells
"CPLead." From the insert-define menu, I updated the "CP Lead" defintion
from G2:G5000 to G2:G1000, and now my formula returns an NA value. Any ideas
on why the formula now returns this error message? Thanks in advance for
your help!