Repeating expression in formula

[jbarrick007]

Hello everyone.
Im having trouble simplifying a repeating phrase in a formula I continually copy and paste and think there must be a slightly easier way.

The formula is: =CONCATENATE("< PHASE 1> ","(",(VLOOKUP("PHASE 1",'Working Datasheet '!A:E,3,FALSE)),")",CHAR(10),(VLOOKUP("PHASE 1",'Working Datasheet '!A:F,6,FALSE)))

But I have 10 PHASES, so I multiple copy and pastes such as: =CONCATENATE("< PHASE 2> ","(",(VLOOKUP("PHASE 2",'Working Datasheet '!A:E,3,FALSE)),")",CHAR(10),(VLOOKUP("PHASE 2",'Working Datasheet '!A:F,6,FALSE)))

I have 10 phases, so every time I copy this formula and want to edit it to PHASE 2, I have three places I have to make the edit from PHASE 1 to PHASE 2. Is there a way to reference the "PHASE x" so it repeats throughout the formula. I know you can set rules like this in VBA but not sure about the formula bar.

 

[mrshl9898]

=ROW(A1) returns a 1, copied down A2=2 etc... Is this something you could perhaps use? Hard to be sure without seeing examples. eg.CONCATENATE("< PHASE ",ROW(A1),"> ",