If any cell in column A:A contains specific text, then show cell 1 to its right in cell C

Copper Contributor

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 shown in Sheet A - Cell A

So if Indirect cell D:D = "Text", then 1 cell left is shown on A1 or something along these lines

If cell Cell A contains specific text, then show cell B in cell C


1 Reply
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.)