Matching Data with set requirements

Hi Experts,

I have a spreadsheet that is capable of assigning names to postcodes based on set requirements but I have now come to a point where I need to reduce the input by users. is it possible to create a formula that works in three stages

Stage 1 - Identify which company (Column D) is working in the postcode given (Column B)
iferror(VLOOKUP(C7,(INDIRECT("'" & B7&"'!$A:$L")),9,FALSE),"") is the formula I used to look at
each companies page

Stage 2 - Looking at the Companies individual sheet (ie where CO 1 is listed, look at sheet CO 1), Identify which staff members
are available by them having an X in the day of the week that matches sheet AUTO ASSIGN CONTROL (in this instance Friday)

Stage 3 - Match the names available to the relevant postcodes, my previous formula required
4 sleeper columns using range F:I, the formula in Column E was then able to use one of the 4 names
without duplicating names

This sheet has come along way but I need extra input, I have attached the file and in yellow I have manipulated the data where the new formula should be but I can not seem to solve it.

Any input would be great

Oh My DAYS!!!!!!!!!! you say hard but replied within the hour and I have spent DAYS trying this one on my own, in fact it took 3 hours stripping back the original data.

seriously though THANK YOU

It worked a charm and I am now rebuilding the website accordingly, I will keep you posted.

Thanks Again

Cool, I managed to extend the range and add all the additional tabs that make up the rest of the companies and it is working producing a 70-80% match which is Ideal, however I can not seem to get one company to register any result despite from what I can so no logical reason why not the tab is NWG and they have postcodes assigned but it does not reveal any matches.

Any Ideas?

Thanks

(hitting head against the wall) thank you