extract data from multiple columns and rows to make a single list - REVISION

Hi All, I previously sought assistance in setting up a "Meal Register-Catering" list by extracting only the dietary requirements detailed on another worksheet (Ward List).

A number of people offered some great assistance awhihc allowed me to cplete that task - I thank you all for that, especially Pete_UK.

Q1. I now need to add a new worksheet to the same file that will allow me to list only the CAT3 category entries on a new worksheet (see CAT3 worksheet). I have tried to modifiy the previously advised formulas to meet the new sheet to no avail and so am seeking your assistance once again.

Q2. Additionally, I written a formula that will insert a date in WARD LIST cell K4 that calculates the date from the number of days entered in cell I4 and the date entered in J4. This formula works well, but I would like to make cell K4 not show any dates if nothing has been entered into cell J5 yet. I'm not sure it can be done or not.

Thanks in advance

Paul

Thanks David, it works perfectly, and you are right, I don't need ISERROR in it. this issue has been annoying me for some time, so now that Q2 is fixed, I just need to resolve the other issue i.e Q1.

Thanks again,

Paul