Forum Discussion
If any cell in column A:A contains specific text, then show cell 1 to its right in cell C
Hello, would anyone happen to know of a formula which would do this: If any cell in 'Sheet B - row C' contains specific text, then I want the cell to the left of the specific text found to be show...
Leaving aside that I don't think you will be too happy with the performance of B!C:C, I think you want A!A1 = If(B!C:C="Text",B!B:B,""). (You will really want to constrain the B:B / C:C.)