Forum Discussion
khjhzw
Mar 09, 2022Copper Contributor
How can I select cells in the column right next to, but in the same rows as the search results?
Hello, I was wondering how I can select all the cells that are in the column right next to and, at the same time, are in the same row(s) as the "search result cells". By "search result cells", I ...
- Mar 09, 2022
mtarler
Mar 09, 2022Silver Contributor
I think your best is
a) use a formula in column C like: =IF (B2="cat", A2, "") and fill down