Extension to an existing formula.

Hi All,

I have the following formula, which basically looks up the name and plots the different lines into certain cells on another spreadsheet.

what I would like it now to do, is to miss out any jobs where it is indicated in the Next Service Type as a Mini.

I have attached an example of the sheet for you to see what i'm needing.

thanks in advanc efor your help

Cheers

donna