I apologize as I should have gone into more detail in my previous post.
The following has to do with tracking invoicing: date submitted; date approved; number of days to approve. I will use the actual cell addresses taken from my spreadsheet.
F3 – INVOICE SUBMITTED
G3 – INVOICE APPROVED
The formula below calculates the number of days it took to approved the invoice. The date submitted and approved are entered manually.
In another cell is the TYPE CODE. This indicates the particular vendor and type of work that was done. Initially, this is entered from a drop down list, i.e., LMN-WX or XYZ-WX.
When the APPROVED DATE is entered, the calculation above is executed. My goal is to automatically change the TYPE CODE to PAID by appending the letter P to the particular vendor, i.e., LMN-WXP or XYZ-WXP when the APPROVED DATE is entered.
In turn this executes a SUMIF which calculates by LMN and/or XYZ.
Therefore, CONCAT or CONCATENATE will not meet the requirement. Neither will manually searching/changing. I want to utilize the capabilities provided/derived within CALC.
Thanks In Advance,