S
Stephan Grunwald
Hi all,
I'm a bit of a MS novice so I apologize if the following question is mundane.
I have an array (A1:A25) and I have written a formula in each cell that ensures only one cell will populate with text. All other cells that do not match the criteria will populate as blank cells.
My question is, how would I go about searching for the cell that contains the text and then returning the text from the cell? The text is dependent on other cells, so I cannot just set one cell equal to another.
Please let me know if I need to elaborate more.
I'm a bit of a MS novice so I apologize if the following question is mundane.
I have an array (A1:A25) and I have written a formula in each cell that ensures only one cell will populate with text. All other cells that do not match the criteria will populate as blank cells.
My question is, how would I go about searching for the cell that contains the text and then returning the text from the cell? The text is dependent on other cells, so I cannot just set one cell equal to another.
Please let me know if I need to elaborate more.