Mar 08 2023 08:40 AM
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
Mar 08 2023 11:25 AM