How to add a Parenthesis around a name in cell

[cartica]

Hi-

Right now, I am using an index match to find a name. It returns it correctly, but is there something I can add to formula to to return the name, and put the name in parenthesis. Example: currently it returns name Chile, but I want (Chile).

Please Login or Register  to view this content.

Thanks

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[cbatrody]

Hi,

Please change the formula as following-

="("&INDEX($A$53:$A$79,MATCH(P41,$B$53:$B$79,0))&")"

[cartica]

Thank you, that works.

[TMS]

You're welcome. Thanks for the rep.