too many arguments

[HPIMICHAEL02]

hey guys,

im boggled, this formula works one way but the other way it doesn't work and throws an error.
works:

Please Login or Register  to view this content.

Throws to many arguments

Please Login or Register  to view this content.

[shukla.ankur281190]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[FDibbins]

Try breaking the components apart and test each 1....

=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),"")
)

You can then see which parts are doing what, and which parts are not behaving

This probably wont fix anything, but you could probably shorten these bits...
IF(O3<>0,TEXT(O3,"h:mm AM/PM"),""),
IF(O3<>0," C/O",""),

to just...
IF(O3<>0,TEXT(O3,"h:mm AM/PM C/O",""),

[Monimonika]

Please Login or Register  to view this content.

I didn't look through the entire formula, but already at the first IF statement you are missing a ")" after the "value if false" part.

=CONCATENATE(IF(J3="VM",VLOOKUP(F3,_VME,4,0),"",IF(VLOOKUP(...

should be:

=CONCATENATE(IF(J3="VM",VLOOKUP(F3,_VME,4,0),""),IF(VLOOKUP(...