Hi i have been asked to help come up with a spreadsheet for work and i am a little out of my depth, basically i have a table of multiple rows and columns that i wish to link to another cell, if all of this data matches 1 criteria i want this to come up as good, if any of the data in this table matches a second criteria i want it to come up as ok, and if any of the data matches a third criteria i want it to come up as bad even if there is any data in any of the other cells that match the first 2 criteria.

thanks in advance for your help