Multiple lookup fields to multiple tables off 1 field

A way for one linked field to perform vlookups across two tables if the field exists in both tables