Can I run 2 formulas on same workbook?

ghrek

Board Regular
Joined
Jul 29, 2005
Messages
193
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
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
10,824
Office Version
  1. 2019
Platform
  1. Windows
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,655
Messages
5,524,136
Members
409,562
Latest member
meeranaskar

This Week's Hot Topics

Top