Hello,

Thank you for providing the code. It works perfectly.

However, I need to rewrite the formula I wrote because it was flawed. I tried copying the code you provided me but I couldn't replicate your code. Here is the formula that I wrote:

{=IF(OR([@Division]<>"Billing",[@[Task Type]]="Non-Billable"),"",IFERROR(INDEX(T_6[Billing Cycle],MATCH([@Team],T_6[Team],0)), IFERROR(INDEX(T_9[Billing Cycle],MATCH([@[Submitting Assistant]],T_9[Submitting Assistant],0)),IFERROR(INDEX(T_8[Billing Cycle],MATCH([@Office],T_8[Office],0)),IFERROR(INDEX(T_7[Billing Cycle],MATCH([@Office]&[@[Billing Group]],T_7[Office]&T_7[Billing Group],0)),"By Request")))))}
I hope you can help me again to translate the formula into VBA code similar to what you did in the previous formula.
Thank you in advance for your help.