Quote Originally Posted by davesexcel
Give me a break!
I showed you how to do it for the first one, are you not able to figure out how to do it for the next one?
I am not going to build your workbook for you.....
Dear Dave,

I am not underestimating your efforts at all.I am sorry if you felt that way..

The reason for seeking help from the Forum was to avoid any helper columns as they would be populated with the first Team Members Name..always

I have used Dynamic Lists in the past using Indirect,Offset,Defined names etc..However, this is a very different situation. I cannot define the Range as its non-contiguos as well as am trying to avoid storing it somewhere as I will have to assign different columns for different Team members..

So, in my case every Row would have a different list drop-down. that was not the only thing but the List has to be created dynamically without defining it....

I have tried different Logics which I have used in the Past but this seems to a bit difficult..

I was using this code to get Multilookup
[ =IF(ROWS(F$2:F2)<=COUNTIF($C$2:$C$21,List!$E$2),INDEX($B$2:$B$21,SMALL(IF($C$2:$C$21=List!$E$2,ROW($C$2:$C$21)-ROW($C$2)+1),ROWS(F$2:F2))),"") ]

This gives me the four Tasks for Sarah, but I am failing to use it in a drop-down as well as it does not change for anything in the next cell E3..

I am sorry for phrasing in this manner..
HTML Code: