Creating a New Column in R Conditioned on Values in Another Column and Row Using dplyr or Base R

Overcoming the Limitations of sapply: A Guide to Efficient Vectorized Operations in R