Formula Help Required Please!! Possible Array?

Copper Contributor


Hi All,

Looking form some help here with a formula, not sure where to begin to be totally honest.
I have a workbook that has multiple tabs which relate to different sites on a contract.
Site 101
Site 102
Site 103
The sites are all on one tab, the ‘Summary’ tab is on a different tab.

Each site has different services and different staff working there. The services are Security, Cleaning & Catering.
I have n ‘Summary’ tab, which displays the information at each site.

The ‘Summary’ tab provides an overview of each service & employee info, that is delivered across the whole contract, each site may have different services.
So the summary tab looks like this:
EX2.png

 

When I type in the site code into the summary tab, I need it to pull through the information from that site and populate the summary tab.

The site list looks like this:
EX3.png

I.e If Site 101 has Security only, then the employee name, number pay rate and hours for those security staff at site 101 will populate the security section of the summary tab.

If site 102 has Security and Catering, then the employee name, number pay rate and hours for those security and catering staff at site 102 will populate the security section and the catering section of the summary tab.

Is this possible?
Thanks, JD.

0 Replies