I need a formula that will look across each row, and return a value from either of 2 columns based on information in another column.
In other words, fill in the "send paperwork to" column with Insurance4All for Jim; BigShield for Robert;Dr. Smith for Michael; etc.
Name Insurance Plan Physician Who updates paperwork? Send Paperwork to
Jim Insurance4All Dr. Jones Insurance Plan
Robert BigShield Dr. Jones Insurance Plan
Michael BlueCompany Dr. Smith Physician
Vincent Insurance4All Dr. Casper Physician
Richard Insurance4All Dr. Doe
Insurance Plan
In other words, fill in the "send paperwork to" column with Insurance4All for Jim; BigShield for Robert;Dr. Smith for Michael; etc.
Name Insurance Plan Physician Who updates paperwork? Send Paperwork to
Jim Insurance4All Dr. Jones Insurance Plan
Robert BigShield Dr. Jones Insurance Plan
Michael BlueCompany Dr. Smith Physician
Vincent Insurance4All Dr. Casper Physician
Richard Insurance4All Dr. Doe
Insurance Plan