#### brockk

##### Board Regular

- Joined
- Jul 1, 2006

- Messages
- 146

is there a way to shorten this formula:

{=IF($A141="","",IF(OR($F141=0,$D141="",$D141>39814),INDEX(DBASE!$L$3:$FC$483,MATCH($A141,DBASE!$A$3:$A$483,0),MATCH($R$1,DBASE!$L$3:$FC$3,0)),VLOOKUP($A141,TEMPLATE!$B$7:$N$107,13,FALSE)))}

for some unknown reason I get #n/a error and don't know why because this is a copied formula and all other cells are reporting correct values except this one. Any suggestions? Thanks in advance.