Hi all, I’ve looked everywhere I know to and can’t figure out how to do this. I’m also not entirely sure how to ask.
I am trying to search for a value in one cell and replace another cell based on that value. For example, I want to search in B2 and replace A2 if I find a certain value in B2. But I also want it to replace anything in column A that matches A2.
Below is an example of original data (on the left) and what I want it to end up as (on the right). In this example, it is searching column B for the characters “XYZ.” It is then replacing the value in A2 with “NUM,” since it found “XYZ” in B2, and replacing A1 with “NUM” as well since A1 matches A2. It’s doing this for the others with “XYZ” as well. I did this manually for the example, but I want to do it with a formula, since I’m working in a sheet with nearly 100000 rows.
I know how to search for B2 and replace A2 based on that, but not how to have it replace both A2 and any matches to A2.
Is there a way to do this?