Formula change?

[Spraggs]

Hello All,
I'm wanting to change the formula below so if W3 = UKDobsonCr or UKCrossfMa etc.......

=IF(W3="UKDobsonCr", CHOOSE(COUNTA(B3,M3,R3,V3)+1,"","TECHNICIAN","STORES MANAGER","PURCHASING","COMPLETED"), CHOOSE(COUNTA(B3,R3,V3)+1,"","TECHNICIAN","STORES MANAGER","PURCHASING","COMPLETED"))

Regards Jase

 

[Andrew Poulsom]

Like this?

IF(OR(W3="UKDobsonCr",W3="UKCrossfMa"),CHOOSE(COUNTA(B3,M3,R3,V3)+1,"","TECHNICIAN","STORES MANAGER","PURCHASING","COMPLETED"), CHOOSE(COUNTA(B3,R3,V3)+1,"","TECHNICIAN","STORES MANAGER","PURCHASING","COMPLETED"))

 

[Spraggs]

Cheers Andrew