Formula is missing an opening or closing parenthesis

[howard]

I have the following formula below


However , I get a message "Formula is missing an opening or closing parenthesis

 =if(a2="","",IFERROR(INDEX('C:\My Documents\[Stock Report.xlsm]Shirts'!$A:$A,MATCH(A2,'C:\My Documents\[Stock Report.xlsm]Shirts'!$I:$I,0)),"815748")

If I remove this part of the formula

 =if(a2="",""

, then the formula has no errors

Kindly amend my formula

 

[Fluff]

You need to add another ) to the end of your formula.

 

[howard]

Thanks for letting me know Fluff

 

[Fluff]

You're welcome & thanks for the feedback.