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

Sorry, but I have a personal rule where I won't open files with macros or that are bigger than 50kbs.

I just noticed that you're using Excel 2007.

You can replace all of this:

LOOKUP(REPT("Z",255),CHOOSE({1,2},"",

With the IFERROR function.

=IFERROR(LOOKUP(1E100,......),"No_Data")

stripped file - description would still apply

in the book4 workbook look in I3 and I4 for formula - in other file look in Last service parked in PRIORITY sheet

Ta Nigel