If multiple query

[Christopherdj]

Hi and thanks for looking at this for me.
I'm looking for a formula (assume an if function) where the outcome is required in Column A.
If cell to the right is blank, then it will check the next, and so on - finishing at column G.

Should All cells to the right be blank - it would be nice to have "Not Checked" as a result.
Some cells have text, but some have dates - I'm unsure of how to ensure the date is replicated also.

File is attached, thanks again for any assistance. I think it's relatively simple formula but I'm stumped.
Regards
Chris

[Sam Capricci]

try this... =IF(B2<>"",B2,IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,IF(F2<>"",F2,IF(G2<>"",G2,"Not Checked"))))))

[MarvinP]

Hi Chris,

This is a start to an answer using TextJoin. See the attached.
FirstNonEmptyCell.xlsx

I'm not sure how to test for text vs values but the above is a start.

[Christopherdj]

Thanks Marvin, yes it works but not for the date. Thanks for attempting it.
Sam's answer above works, I only have to format the cells to date format.

[Christopherdj]

Thanks Sam, works fine with a quick format of cells. I had tried but was using >"" instead of the <>"".

[Sam Capricci]

You're welcome, glad I could help.