Hello. Thank you for your question. I appreciate the opportunity to be of service.This formula will work for two choices:IF(AND(OR(D6="Somerset T"),D6="Something Else"),C6,"")
If you are satisfied with my answer, please rate my services. A positive rating allows me to be compensated for providing information and advice here.