Formula is missing an opening and closing parenthesis

Hi Everyone,

I know this is a simple formula but I am getting this error "the Formula is missing an opening and closing parenthesis". I am not sure which parenthesis is missing.

if(H6="Void","",VLOOKUP(A6,'Action Item'!$A$6:$X$563,17,FALSE)

your IF function is not closed the closing parenthesis at the end only closes the function VLOOKUP

Formula:

Please Login or Register  to view this content.

Originally Posted by Roel Jongman

your IF function is not closed the closing parenthesis at the end only closes the function VLOOKUP

Formula:

Please Login or Register  to view this content.

Thanks so much Roel. It drove me crazy for like 15 minutes. I really appreciate it.