If I have a range of data from A1:F1 that is all blank except for E1 which has Axe, and I want to put a formula in G1 to search the range and return the text, how do I do it?
What I tried originally was IF(A1:F1<>"", A1:F1, ""). I tried this as an array formula and it returned blank. When I put the text in A1, it returned the text. I am not too familiar with array formulae and what I am doing wrong.
Eventually I want to apply this formula to multiple rows and in each row, the text may appear in a different column.