Calculated Column with IF and from different table

HI GUYS and GALS   is it poassable to add a column to a exsting table based on another table using a if statement   i.e    Table one                                                             ...