microsoft excel – Need to determine if a row in a data set meets the parameter of acceptable or not

In one table I have parameters. This represents the number of instances for Requested and provides the allowable number of Missed for those instances e.g. if 11 requests have been received and 1 was missed then this is allowable, if 11 requests have been received and 2 were missed this is not allowable.

In the next table is the data than needs to be assess to see if it is allowable (Yes) or not (No). I have tried a few different If & And formula’s but can only seem to get the data to either assess against the first row of the parameters.

enter image description here