I am trying to update an entire column (col #1) based upon specific values in
col. #2. Column #1 has random entries, no range and no sorted order.

For example, 30, 365 & 1095 = 03; N/A or 0 = 10.