That works perfectly !!!
Originally Posted by TMS
Quick Question though ... due to this being related to team members and the managers which can change at anytime I was wondering if it was possible to do the following .....
The file is laid out in format of Column A being the Managers name and B being the Staff Members name rather than the formula itself containing the managers name to the relevant tab could this be fetched from the cell in column A ?
So as above instead of Manager1 it could say A2 which would contain the managers name which is an exact copy of the tab names
So at least then if Managers or Team Members do change this can be updated within Column A and / or B which would automatically update the vlookup value in the formula ?