vlookup to check multiple rows

Hi All,

I have a summary list of orders received, the complete order has a unique number, but in that order there could be 50 items

these separate 50 items are listed on another sheet, each of the 50 items is listed with the same unique number beside it

Example:

Order00114-50 is listed on the summary sheet, and on the other sheet, the sub details are listed as so in column A and B

Order00114-50 - Screws - Yes
Order00114-50 - Washers - No
Order00114-50 - Bolts - Yes

Beside each item I have column "C" titled "inspected" with a "Yes" or a "No"

I need a formula that will look to see if all orders have "Yes" in column C, and then return the result to my summary sheet

So the formula needs to find all instances of the unique code, this quantity varies with orders, and return a "Yes" or "No" value to my summary sheet, the example above should return a "No" as all items have not been inspected

Hope that makes sense, thanks in advance for any replies

Simon

It would make more sense if you made up a sample workbook and attached it to your post.

Hi Simon,

See attached file helps.Mostly self explanatory. simon_example.xlsx

Elayaz

My guess was more like this, my reason for suggesting a sample workbook was that this could be open to interpretation in several ways.