Hi PC

Sorry that is a typo error, even with the correction the error message still
appears.


"PC" wrote in message
...
I get an error in the formula

in the last MATCH you have "Cont$C77" it should be Cont!$C77

Possibly that is the problem

HTH

PC

"Pat" wrote in message
...
When recording a macro an 'Unable to record' message appears when I try
to
record a formula. Here is the formula that seems to cause the problem:



=IF(ISNA(MATCH(Cont!$C77,Purchases!$BM$24:$BM$2000 ,0)),"",IF(INDEX(Purchases

!Y$24:Y$2000,MATCH(Cont!$C77,Purchases!$BM$24:$BM$ 2000,0))="UpdateCC",INDEX(

Purchases!$AP$24:$AP$2000,MATCH(Cont$C77,Purchases !$BM$24:$BM$2000,0)),""))

Anyone know why this should happen?

Thanking you in advance.
Pat