This seems like a simple problem but I can't find any other examples on this and it is making me nuts!
Excel 2007 - I want to search cells AO9:AO999 for text...any text. There should only be one cell of text in that entire range at any given time based upon a set of other arguments in any given row. I then want that text to be returned to cell AO6.
The logic is something along the lines of this formula in cell AO6: =IF(you find any text in AO9:AO999, return that text,"")
Any help would be appreciated!
Excel 2007 - I want to search cells AO9:AO999 for text...any text. There should only be one cell of text in that entire range at any given time based upon a set of other arguments in any given row. I then want that text to be returned to cell AO6.
The logic is something along the lines of this formula in cell AO6: =IF(you find any text in AO9:AO999, return that text,"")
Any help would be appreciated!