Required for Excel formula suggestion - reg

Dear Excel Expert,

Kindly give the suggestion for the below topics.

I have three excel sheet.  1. In master sheet all the UTR No's available for the particular supplier list wise. 2. Second sheet particular supplier UTR No's available but not available in Supplier name. 3 third sheet particular supplier UTR No's available but not available in Supplier name.

in my question is if i am compared master sheet 1st excel sheet UTR no's not available means automatically check second excel sheet and result should be produce. in this case Vlookup formula was not used due to data want to left hand side result.

Thanks & Regards

Satheshkumar T M.Com., MBA

+91 9865850740