Find missing record

this is my first excel

this my second excel

i want to compare column Transaction reference of both excel and in first excel have 4 records comapare all this 4 record with other excel and if any one record is missing from 4 record then message record is missing else all record found