VLOOKUP

SELECT tbl_Info.Contract, IIf([tbl_Info]![Contract]<>"","Found","Not Found") AS Results

FROM tbl_RAW INNER JOIN tbl_Info ON tbl_RAW.Contract = tbl_Info.Contract;