Forum Discussion

khjhzw's avatar
khjhzw
Copper Contributor
Mar 09, 2022
Solved

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 ...
  • HansVogelaar's avatar
    Mar 09, 2022

    khjhzw 

    In C1:

     

    =IF(B1="cat",A1,"")

     

    Fill down to C5.

Resources