Search a Function for X if found do Y

[Bomasterflex24]

Hello All -

When I copy a Balance Sheet from a website the negative figures map over like this "(100,000" as the other parenthesis pastes to the next cell.

I then have my own formatted Balance Sheet elsewhere on the worksheet and am able to use Index(Match) to pull over the initial figures I need but I pull over "(100,000" so I just want to wrap the INDEX(MATCH) with a function that looks for "(" and if found just adds the ")" to the end of the result.

INDEX(MATCH) result = "(100,000"
Desired INDEX(MATCH) result "(100,000)"

Thank you

 

[kweaver]

If your values are in column A, this will change the values with a leading left paren to actual negative numbers which you can format as you need.

=1*IF(LEFT(A1,1)="(",A1&")",A1)

 

[Bomasterflex24]

Thank you so much kweaver. Sorry for the late reply, I was at an internship last year and trying to start the good habit of utilizing forums. Now I am at another internship utilizing Excel as a financial analyst. I could have sworn I have logged in since June 5 but perhaps I did not check my replies section.

Your formula worked great! Thank you

As a non-imperative follow-up question,
How would I embed your formula with my Lookup function I used? The formula below is in cell J6.

Presented below I am able to make due with simply migrating the data across the workbook to different functions (like a car wash) which I did for a more extensive data cleaning project at a previous internship.
I am aware I will need to fully learn how array functions works to solve circular referencing or better yet, get good at a programming language, but I have heard that baby steps are needed and to be more linear in my learning aspirations. Not quite sure how to know where to embed a new function as Excel is all horizontal and not really intended to be coding which is vertical with indents where you would embed a formula to do something with a result and then have the string continue onward.

 

[kweaver]

I'm a bit unclear as to what you want in J6? Should it be (5000) or (1000)?

 

[Bomasterflex24]

(1000)
Just looking to put be able to have all the functions in one cell vs having it go through multiple columns step by step like a car wash. The step by step way is doable, just for continued logic writing improvement.