determining minimum value based on arbitrary associations...

Okay, I have four sheets (see attached workbook)...

source data: a set of Product IDs and their quantities

associations: those same Product IDs along the row axis with a set of "Models" as column heads and an arbitrary set of boolean values associating each Product IDs with various (possibly multiple) models.

threshholds: the criteria that I'm trying to determine.

status: this is where the formula I can't figure out goes...

Basically for each Model (along the row axis of the status sheet), I need to know if ANY of the Product IDs associated with that model (in the associations sheet) meet the various criteria, and show a simple text result as shown in the threshholds sheet.

THANK YOU SO MUCH!

I would suggest posting a sample workbook instead of describing the data in the forum.

Also what is the relationship between models and ID#s?

Actually, in the sample worksheet you attach make sure to include the following.
Representative data set(s)
Representative Summary with typed in numbers indicating where you want a formula - give a few examples so we can understand what you are trying to accomplish.