jbarrick007
New Member
- Joined
- Jul 9, 2020
- Messages
- 36
- Office Version
- 365
- Platform
- Windows
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.
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.