luisitocarrion1900
Board Regular
- Joined
- Oct 30, 2017
- Messages
- 194
- Office Version
- 365
- Platform
- Windows
Hello,
I have a sheet name "AIM" and a sheet name "AI Status"
I need to place a formula on the sheet named "AIM" column named "Post Status", that if Column named "Business Unit" data matches the data on the sheet Named "AI Status" Column named "Business Unit" and the data on the sheet named "AIM" column named "Submission Status" says "A/LM/PMP/PM Approved" and enter the words "Completed" in the AIM sheet column named "Post Status" but if the date in the sheet named "AIM" column named "Extension Date" is passed today's date and the words A/LM/PMP/PM Approved or PMO Approved are not in sheet AI Status column Named "Submission Status" enter the words "Delinquent" in sheet named "AIM" Column named "BU Status" but if the date has not been met and the the status of A/LM/PMP/PM Approved or PMO Approved is not there enter Pending
See both sheets below the first sheet is the AIM Sheet and the second will be the AI Status Sheet.
AIM Sheet
AI Status Sheet
I have a sheet name "AIM" and a sheet name "AI Status"
I need to place a formula on the sheet named "AIM" column named "Post Status", that if Column named "Business Unit" data matches the data on the sheet Named "AI Status" Column named "Business Unit" and the data on the sheet named "AIM" column named "Submission Status" says "A/LM/PMP/PM Approved" and enter the words "Completed" in the AIM sheet column named "Post Status" but if the date in the sheet named "AIM" column named "Extension Date" is passed today's date and the words A/LM/PMP/PM Approved or PMO Approved are not in sheet AI Status column Named "Submission Status" enter the words "Delinquent" in sheet named "AIM" Column named "BU Status" but if the date has not been met and the the status of A/LM/PMP/PM Approved or PMO Approved is not there enter Pending
See both sheets below the first sheet is the AIM Sheet and the second will be the AI Status Sheet.
AIM Sheet
AI Status Sheet