Thank you!!!! Helping to "recode" a huge data set with this exact same issue and your solution just saved at least 36 hours of manual data re-entry and/or the time to figure out how to write VBA multi-conditional loops. Phew.