Hi, I have a ongoing weekly report where I have to add reason codes based on a few factors.
What I have been doing is using a VLOOKUP based on a status (column g) to return the matching value from another sheet and insert into Column U. This part is working fine. However what I am still having to do manually is in column M, if that date is 3 days in the past from today, I have to manually in a reason code (in column U) This would say No Movement in 3+ days.
Any ideas what kind of a formula I can use? Thanks in advance
What I have been doing is using a VLOOKUP based on a status (column g) to return the matching value from another sheet and insert into Column U. This part is working fine. However what I am still having to do manually is in column M, if that date is 3 days in the past from today, I have to manually in a reason code (in column U) This would say No Movement in 3+ days.
Any ideas what kind of a formula I can use? Thanks in advance