Create new column with related fields from 2 tables (In Table view)

[Anonymous]

Hi, Table 1 contains Jobname column with X,Y,Z. I want to create another column Time in this table with related fields from other two tables matching this X,Y,Z. Table 2 contains time of X, Table 3 contains time of Y, Z. 

TABLE 1			Table 2			Table 3			Result Table should be like this
jobname	Time		jobname	Time		jobname			jobname	Time
X			X	9:00 AM		Y	10:00 PM		X	9:00 AM
Y						Z	11:00 AM		Y	10:00 PM
Z									Z	11:00 AM

[mh2587 · Accepted solution]

--Try this
Time = 
IF (
    NOT ( ISBLANK ( LOOKUPVALUE ( Table2[Time], Table2[jobname], Table1[jobname] ) ) ),
    LOOKUPVALUE ( Table2[Time], Table2[jobname], Table1[jobname] ),
    LOOKUPVALUE ( Table3[Time], Table3[jobname], Table1[jobname] )
)

[Anonymous]

It is not working for 4 tables. But working for 2 tables. For more than 3 tables? Can you show format?