You need to complete adding the data for each company to the Active Client Table sheet, rather than have individual sheets for each client. Then you will be able to do what is shown in the attached file.
I have put a MATCH formula in B2 of the Branch Active Customers sheet to determine in which row of the client list in column A the client appears in for the chosen client - this should be the same column number (-1) that the data appears in the Client Table sheet. Then in D4 I have this formula:
which is then copied down. It retrieves the appropriate data from the Active Client Table sheet, which you can see by changing the selected client in C3.
Hope this helps.
Pete
Bookmarks