Can I run 2 formulas on same workbook?

[ghrek]

Hi

I have a workbook thats got this formula in column F.

=IF([@Source]="","",IF(ISNA(MATCH([@ID]&"|"&[@Field2]&"|"&[@Date]&"|"&[@Value],INDEX($J$2:$J$7000&"|"&$K$2:$K$7000&"|"&$L$2:$L$7000&"|"&$M$2:$M$7000,0),0)),"Missing",""))

Im trying to repeat the formula in column "O" so it looks in columns B-E for missing data but it not working.

Any ideas?

Thanks

 

[jasonb75]

Please describe 'not working' in more detail.

Do you get the message 'There is a problem with this formula'?

Do you get an error result such as #REF , #VALUE , #N/A or similar?

Do you get a result different to that which you expect?

Something else?

It looks like it should be an array formula, so did you remember to array confirm it with Ctrl Shift Enter?

 

[ghrek]

It looks like it should be an array formula, so did you remember to array confirm it with Ctrl Shift Enter?

Didnt do that let me try that first.


Thanks