Ok, I'm not sure if this is possible, but here's what I need.
I have data in cells A17:AC17
In AD17, I need a formula that will look up each cell in the range and give me the contents of that cell if a particular word is found in the cell.
For example:
I need a formula in AD17 that will scan A17:AC17. If the word Email is found in one of those cells in that range, I need the contents of that cell placed into cell AD17.
Hope it can be done. Please let me know.
Thanks so much!!
I have data in cells A17:AC17
In AD17, I need a formula that will look up each cell in the range and give me the contents of that cell if a particular word is found in the cell.
For example:
I need a formula in AD17 that will scan A17:AC17. If the word Email is found in one of those cells in that range, I need the contents of that cell placed into cell AD17.
Hope it can be done. Please let me know.
Thanks so much!!