In match search how to display "NO DATA" if no instance of criteria

Thanks for prompt reply - I am attaching a copy of the file

If you first check sheet "schedule", the data is recorded in range I:N and a number of entries have a Checked checkbox under priority service. Under ADD INs above a macro will pick the data required and forward it to sheet PRIORITY. In the column G you will find the last instance of an A service for that machine. (USE THE CLEAR CONTENTS ADD IN to remove the data before the next PRINT PRIORITY)

not elegant but I'm never left finish anything

any further details required please ask

Rgds Nigel