Hi guys, i have one master sheet, then another excel with several sheets. my task to get a formula that will find one unique value in the master sheet and v look up across the other excel with several sheets and return a yes, and an error if the value is missing