I need to get data for a particular cell from same column (Multiple vlookup) and from different columns. For example I have person 1 to 10 who are assigned to different projects. Now I have data project wise. I need the data person wise. So in my first column there are name of the companies and then in the next columns (Which go till BA in the original sheet) there are persons names. I can get the names from one column using index and if and small (Which i learnt in this forum some years agao), however I am not able to get the names from different columns. I have attached the sheet to show my problem and expected solution. Please let me know if you need more information.