I need a function that will bring in text if it exists in one of every other cell on the same row to the end of the worksheet.

So for instance, the function will reside in cell A1. If text exists in C1 or E1 or G1 . . . . in that series, all the way to the end of the worksheet, I need that text. Assume text only exists in one of the cells of interest (in only one of the odd columned cells on that row).

I will have text in the even columned cells (B1, D1, F1 . . . ) that I will want to ignore.

I also need as a separate function the cell address where that text arrived at above is found.

Thanks much!