Create a new column based on conditions

[nirgrahamuk]

I can provide an example using fuzzyjoin if you first turn your example into a reprex.
Here is a guide for how to do that. FAQ: How to do a minimal reproducible example ( reprex ) for beginners