I am working on a form where if B14 is populated with a Person's Name C22 populates their contact info... (which is easily done)
However, I am looking to have if B14 is blank (no name populated) but B20 has a name the same C22 populates the same contact info...
Is there a formula or work around to achieve this?
Thank you,
However, I am looking to have if B14 is blank (no name populated) but B20 has a name the same C22 populates the same contact info...
Is there a formula or work around to achieve this?
Thank you,