Vacant

[Elston]

I have a workbook that i track rent. Tenant name is recorded in Column B (Cell B4 starts the list) When a tenant moves out i type VACANT in column B
In column I the amount of rent is entered.
Is there a formula i can put in column A that will make the word VACANT appear in in column B when Column I is blank?

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel-questions/1047378-populate-different-cell-than-formula.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

You have replies in your original thread that you never responded to.