(Array formula) A cell populates a certain text if another cell is filled (or has a date)

[Alchemancy]

Hey all,

I am trying to remember the syntax for an array formula that populates cells in a column if another cell is not empty, preferably with a date. This sounds so simple, but I can't seem to find this in any search query. Let me describe first with a visual, then explain:

example.png

The formula should be in A1.
If B2 is populated, B1 should say a particular text. (I.e. "Shipped")
If C2 is populated, the text in B1 should change to another text. (I.e. "Received")

This should be a singular array formula that works the same on the next rows.

Any suggestions are greatly appreciated! Thank you!

[menem]

Could you please upload a sample workbook with the wanted result (see yellow banner above).
I don't understand a very long text. T_T

Regards.

[Alchemancy]

Hi Menem,

I'm trying to make a formula similar to:

={"Status";ARRAYFORMULA(IF(isblank,false,(B2),B1,"Text here",(C2),C1,"Text here"))}

This is not correct, but I want to know the correct syntax.

The attachments feature doesn't work so I can't upload an example sheet. Sorry?

screenshot.png

[AliGW]

ARRAYFORMULA is Google Sheets function, so why did you post in the Excel section???

There are instructions at the top of the page explaining how to attach your sample workbook. YOU NEED TO FOLLOW THEM!

[JohnTopley]

If you follow the instruction on the yellow banner at the top of the page you should be able to upload a workbook

I believe ARRAYFORMULA is a Google function so are you looking for a Google solution and/or Excel equivalent?

[Alchemancy]

Okay yes. I will need the Excel equivalent of an array formula, not the Google sheets. Please see attached.

[JohnTopley]

Please add some expected results as there are multiple columns (customers) with same date

[Alchemancy]

I suppose the date themselves don't matter as much as the cell itself being populated. Not sure if this is better served as a ISBLANK or ISDATE, but I just want the A column cells to say certain "text" if the B and C columns of the same row get populated, dates or no.