[TABLE="width: 607"]
[tr]
[TD="class: xl158, width: 574, bgcolor: transparent, colspan: 7"]I would like a formula for cells in column "U" that will do the following things[/TD]
[TD="class: xl155, width: 184, bgcolor: transparent"][/TD]
[TD="class: xl156, width: 51, bgcolor: transparent"][/TD]
[TD="class: xl158, bgcolor: transparent, colspan: 8"]1. If column "T" has the word "MD" anywhere in the corresponding cell, then return the number 1 in corresponding column "U"[/TD]
[TD="class: xl156, bgcolor: transparent"][/TD]
[TD="class: xl158, bgcolor: transparent, colspan: 8"]2. If column "N" has the word "Processing" in the cell, then return "Processing" in corresponding column "U"[/TD]
[TD="class: xl156, bgcolor: transparent"][/TD]
[TD="class: xl158, bgcolor: transparent, colspan: 9"]3. If column "T" has the word "MD" anywhere in the corresponding cell listed 2 times, then return the number 2 in corresponding column "U"[/TD]
[/TABLE]