Concatenating text within an Array Formuula

[howard]

I have the following array formula below, which gives me the correct result

 =INDEX(D:D,MATCH(1,SEARCH("Grand*",A:A))) ]/code]
 
Alt+Shift+enter


I have tried add text to this, but get message opening or closing Parenthesis missing


[code] ="The Balance on a/c 975415 is "&TEXT(INDEX(D:D,MATCH(1,SEARCH("Grand*",A:A,"$,##0.00")))

It would be appreciated if someone could kindly assist me in amending the above formula

 

[Roger Govier]

Hi Howard

You're correctly working formula has three closing parens.
You are wrapping this in a text function, which adds an opening parens, so you would need another closing parens.

[COLOR=#333333]="The Balance on a/c 975415 is " & TEXT(INDEX(D:D,MATCH(1,SEARCH("Grand*",A:A,"$,##0.00"))))
[/COLOR]

 

[bhos123]

="The Balance on a/c 975415 is " & TEXT(INDEX(D:D,MATCH(1,SEARCH("Grand*",A:A,"$,##0.00"))),)

 

[howard]

Thanks for the help