brockk
Board Regular
- Joined
- Jul 1, 2006
- Messages
- 170
- Office Version
- 2013
- Platform
- Web
Hi to all,
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.
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.