hey guys,

im boggled, this formula works one way but the other way it doesn't work and throws an error.
works:
[/=CONCATENATE(IF(VLOOKUP(F3,_CLEAN,14,FALSE)=0,"",VLOOKUP(F3,_CLEAN,14,FALSE)),IF(O3<>0,TEXT(O3,"h:mm AM/PM"),""),IF(O3<>0," C/O",""),IF(J3="VM",VLOOKUP(F3,_VME,4,0),""))
Throws to many arguments
=CONCATENATE(IF(J3="VM",VLOOKUP(F3,_VME,4,0),"",IF(VLOOKUP(F3,_CLEAN,14,FALSE)=0,"",VLOOKUP(F3,_CLEAN,14,FALSE)),IF(O3<>0,TEXT(O3,"h:mm AM/PM"),""),IF(O3<>0," C/O",""),IF(J3="VM",VLOOKUP(F3,_VME,4,0),"")))