Create an additional sheet e.g. RequestTypes with columns RequestType, Target.

Define the created table as Table (e.g. tRT), or define a dynamical named range (e.g. nRT) which includes datarange of created table.

As a bonus, you can define the data column of RequestType in tRT or 1st column of nRT as named range, and use this named range in your original table as Data Validation List source to select TypeOfRequest values.

Your formula OnTarget formula will be
in case you used defined Table:
in case you used Named Range:
The formula returns TRUE when number of workdays is less or egual compared with target for reguest type, and FALSE when otherwise. When either TypeOfrequest or number of workdays remaind empty, an empty string is returned.


There is no limitations for target values - all requests may have same target, or every request type can have different target. It is up to you how you define them in RegustType sheet.

Thank you so much for the quick response. This is way beyond anything I know but gave it a go and have attached the results. I think it's nearly there.

Instead of returning FALSE or TRUE, can it return Yes or No?

Also, think I may have done something wrong as the drop down list also has my target values??

Once last thing, is this working out network days as we only work Mon-Fri? I also need to factor in the public holidays so they are not counted.

So sorry for list of queries but hope you can help.

Not sure it's relevant but I'm using Excel 2016.

Thanks.

Lynn

Attached Files

Target Workbook.xlsx (11.2 KB, 12 views)