This is helpful thanks. According to the link, the formula below must have
become volatile because it refers to other worksheets and I was inserting
columns.


--
Brevity is the soul of wit.


"Jim Thomlinson" wrote:

Check out this link...
http://www.decisionmodels.com/calcsecretsi.htm

The entire site is actually a really good read and worth bookmarking.
--
HTH...

Jim Thomlinson


"Dave F" wrote:

I have the following formula: =IF(ISNUMBER(MATCH(B2,'1 31 07 FAS sheet
1'!$AG$2:$AG$65536,0)),"Matched",IF(ISNUMBER(MATCH (B2,'1 31 07 FAS sheet
2'!$AG$4:$AG$58232,0)),"Matched","Unmatched"))

If I manipulate other data outside the ranges in the above formula, the
whole workbook recalculates. I've never seen MATCH referred to as volatile.

Thoughts?
--
Brevity is the soul of wit.