Hi

I need to build in a formula that will show if a target is met depending on what is selected from a drop down list in a cell. Each item on the list has a different target. The only way I can get it to work is by having a separate target met cell for each of the 10 items but ideally I would want one formula and one cell showing the result. Not sure I am wording this clearly enough...been working on this all day with no joy.

Here is my drop down list (named range of TypeOfRequest):-

Replacement cards
Work patterns
Password reset
New users
Query
Managers access
Location access
Update/merge record
Close record
Further info requested

Replacement cards and New users have a target of 5 working days to be actioned and all others 2 working days.

The list is in cell A2 and the number of working days taken is in cell B2 and the target met (Yes or No) is in cell C2.



I had tried tweaking a formula that I had used previously for something similar but different list but with no joy, this was:-

=IF(DA3="","",IF(((MATCH(DA3,DocumentType,0)>3)*(E Y3<=5)+(MATCH(DA3,DocumentType,0)<=3)*(EV3<=40))," Yes","No"))

Any thoughts.

Thanks in advance.

Lynn