Hi All,
I have a question about a drop don box and a if
k2 an k3 have names in it k2 Beau k3 john
m2 is drop down $data.$K$2:$K$3
I like to do a if in o2 that would be what ever name is not selected in m2
thanks Beau
=IF(M2=K2,K3,K2)
![[TEST] Document Foundation Community](https://communitytest.documentfoundation.org/images/discourse-logo-sketch.png){kind=logo}
Hi All,
I have a question about a drop don box and a if
k2 an k3 have names in it k2 Beau k3 john
m2 is drop down $data.$K$2:$K$3
I like to do a if in o2 that would be what ever name is not selected in m2
thanks Beau
=IF(M2=K2,K3,K2)