Hi. I have a table in which I assign team members to specific tasks using the vlookup. I would like to each team member should have 20 requests assigned. The rest of requests should receive the status "unassigned". What's the easiest way to do this?
.Range("B2:B" & lastRow).Formula = If(CountIf("B2:B" & lastRow, VLOOKUP(A2,'" & wb1.Sheets("Sheet1").Name & "'!$A$1:$C & lastRow2 & ",2,False))>20,"unassigned",VLOOKUP(A2,'" & wb1.Sheets("Sheet1").Name & "'!$A$1:$C & lastRow2 & ",2,False)
Range("B2:B" & lastRow).Formula = "=If(CountIf(B2:B" & lastRow & ", VLOOKUP(A2,'" & wb.Sheets("Sheet1").Name & "'!$A$1:$C" & lastRow2 & ",2,False))>20,""unassigned"",VLOOKUP(A2,'" & wb1.Sheets("Sheet1").Name & "'!$A$1:$C" & lastRow2 & ",2,False)"