Hi,
Hoping someone might be able to help me with this. Not sure if it is possible.
I have a sheet which shows which consultant is working on a given project in a given week.
As the sheet is organised by project, a consultants name can appear multiple times if they finish on one and move on to another.
On a seperate sheet i am trying to show the availability of the consultants by drawing on the data in the first sheet.
Unfortunately vlookup only gives me the first value and index requires unique values.
Attached is an example spreadsheet. I am trying to combine the data from sheet 1 into sheet 2.
Example.xlsx
Any help would be greatly appreciated.
Bookmarks