Post the formula.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"Ashley" wrote in message
...
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!