IF Function - return values from one table if true, values from other table if false

Hello,

I can elaborate on the requirement, yes. Given a [Full Name] from Table 1, if Table 3 [Connection] contains data for [Employer], return [Connection] Values from Table 3 where Table3[Employer Name] = Table1[Employer]. If Table 3 does not contain data for [Employer], return [Connection] Values from Table 2 where Table2[Full Name] = Table1[Full Name].

The values will be arranged on a matrix. I have an short sample data set to work with (I apologize it is not longer, I have no experience creating sample data).

In my example, the ideal output would be:

Full Name          | Employer                 | Connection

Adam Fisher      | Salmon Emporium   | Brian Null

                                                             | Jeff Robinson

Amy Smith         | Acme Corp              | William Zheng

Bill Hanson         | Hanson Windows    | John Miller

                                                             | Jody Bank

Bill Weber           | Nancy's Daycare     | Sue Pillow

Branden King     | Hanson Windows    | John Miller

Felicia Day          | Amazon                  | Dan Nuss

George Foreman| We Sell Grills          | Don Ham

                                                            | Howard Donn

Larry Vance        | Salmon Emporium  |Brian Null

                                                            | Jeff Robinson

Nancy Weber     |  Nancy's Daycare    | Sue Pillow

Troy Barnes        | Barnes & Noble      | (blank)

Link to sample data: https://drive.google.com/open?id=0B59iuV1_JBMUVFI1d3JRYlJRb0k

Original Post updated with this data.