| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding Text within an Array
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a value or the one next to it in a range NOT array | Excel Worksheet Functions | |||
| Help in finding Value in Index Array | Excel Discussion (Misc queries) | |||
| Finding the least frequent value in an array | Excel Discussion (Misc queries) | |||
| Finding Data in an Array | Excel Worksheet Functions | |||
| Finding Array Formulas in VBA | Excel Programming | |||
Threaded Mode
