Replace IF Formula

Hi

I have built a model which is almost there.

I just have two exceptions I need to account for using formula if possible.

I have a P&L (column B:E) and from this it creates a load file to feed another system (columns J:O).

I also have a helper column which gives me a unique list of account codes, column G.

In column J (highlighted Red) is where I need help….

I need the formula amended so if its 110300 then replace it with 110300120 and if its 111301 then replace it with 111300126. These are the only two exceptions.

What is the best way to achieve this, as clean as possible?

Paul

Since you already have a helper, a second shouldn't be an issue.

H8, copied down

Please Login or Register  to view this content.

...then change column J reference ranges from column G to column H.

Well if he want s to go without any helpers, here's an all-in-one array formula (Ctrl+Shift+Enter) for J8:

Please Login or Register  to view this content.

Array enter THEN copy down.