I'm using the formula: =INDIRECT(SUBSTITUTE(O15,"
","")) on the cell I want only specific data relating to the cell left of it. The cell left of it points back to the name manager name I created. I have 350+ cells in a column i need this formula applied to but the formula can't reference a specific Cell but rather the cell left of it. So instead of referncing cell O15, it would purely reference the cell to the left of it. I've attached the sheet though I've deleted all sensitive data; and columns O and P have the data validation formulas upto row 15.
Many Thanks Experts,