I am required to type into an excel spreadsheet cell the description of the steps that I have applied to a process. There are 10 steps commonly used and I have entered each step into 10 worksheet cells. Every time the process is run, it may require any number of or all 10 steps. I currently use =concat(a1, b1, c1, d1...) to populate the target cell editing the formula each time to choose only the cells containing the steps used in the process.
I am looking for a way to not have to edit the formula every time to populate the step descriptions into the target cell.
i have tried using vlookup, indirect and index, referencing a cell with name ranges for the cells containing the step descriptions, but cannot figure out how to get only the step descriptions i want and not getting errors for the step descriptions i don't want.
What say you excel gurus?
JuanD
I am looking for a way to not have to edit the formula every time to populate the step descriptions into the target cell.
i have tried using vlookup, indirect and index, referencing a cell with name ranges for the cells containing the step descriptions, but cannot figure out how to get only the step descriptions i want and not getting errors for the step descriptions i don't want.
What say you excel gurus?
JuanD