Help ! for trying next row if false

[AbuFragile]

Hi,

I have a problem that I couldn't fix

I'm filling an excel column with a worker for each date, and I have the list of the workers with their admission date,
So I want to fill a worker for each date knowing that worker is admissed before that date.

I tried using IF function and filling with the ID of the worker if it's true, but if it's false I don't know how to try with the next row and so on..

I hope you can help me.

Thank you

[Sam Capricci]

You can get more help if you post a sample workbook with what you have and your expected results.

[AbuFragile]

You will find the excel file below, How I would like the result to be and how I encountered the problem

[GeoffW283]

On Sheet1 it looks like you are allocating 6 employees to each day. Why? By about row 51 (1/9/2016) and subsequently you run out of employees who are around as early as Jan-2016. Don't you in any case want to take employee leaving date (=Demission date?) into account? You only show 200 employees on sheet-2. That means on Sheet1 you entirely run out of employees to allocate at the latest by 2/3/2016.

In summary I really can't grasp what you are trying to do.

Perhaps, if nobody else jumps in, it would help if you could step back and describe in general terms what you are trying to achieve.

Sorry that I can't help further at this point. Perhaps someone else can.

[Bo_Ry]

Not sure about this,

Please try at C2 and copy down.

=IFERROR(INDEX(Tabelle2!A:A,AGGREGATE(15,6,ROW(Table2)/(B2>Table2[Admission Date]),ROWS(B$2:B2))),"")

[AbuFragile]

Yes the idea is allocating 6 employees each day and even if the lists ends, I keep on allocating them at until I allocate all employees in all days.

If I do so I will need to take into consideration admission date indeed, I forgot about that.

So this is just getting more complicated for me, I would appreciate some help as I have limited knowledge about excel functions.

Thanks a lot

[AbuFragile]

It worked until E49 and then it kept on showing blank results, please ask me a question if you want me to clarify the problem.

I really can't figure it out

[Bo_Ry]

Please try again at C2 and check row 302-304 that show E50-E52

=IFERROR(INDEX(Tabelle2!A:A,AGGREGATE(15,6,ROW(Table2)/(B2>Table2[Admission Date]),COUNTIFS(C$1:C1,"E*")+1)),"")

[AbuFragile]

Yes it works perfectly fine thanks !! but there's another problem that I didn't see it coming in the beginning, we can't put an employee at a date when he already resigned

[Bo_Ry]

Add this

=IFERROR(INDEX(Tabelle2!A:A,AGGREGATE(15,6,ROW(Table2)/(B2>Table2[Admission Date])/(B2< Table2[Demission Date]),COUNTIFS(C$1:C1,"E*")+1)),"")

[AbuFragile]

Worked great! Very much appreciated Thanks a lot !!