Dynamic IF Formula that changes value based on input cells

[Data can be tough AP]

Hi Experts,

I am trying to make an interactive sheet that would create a key using specific data to then use as an identifier across multiple sheets. As information is subject to change, I want to add 3 input columns that would essentially:
1. If all cells are blank just uses the same value in the "key" column
2. If I add something in the input cells, then whichever element I change it would override its counterpart in the "new key" column

I've added a manual example to show you what i am trying to do. Looking at this, is there maybe a way to use multple IF functions to do this?

Best regards

 

[Data can be tough AP]

Modified screenshot to show column/rows:

 

[hagia_sofia]

How about:

=IF(AND(ISBLANK(F2:H2)),E2,TEXTJOIN("-",,IF(ISBLANK(F2:H2)=FALSE,F2:H2,TEXTSPLIT(E2,"-"))))

 

[Cubist]

You can shorten to this:

=TEXTJOIN("-",,IF(F2:H2="",TEXTSPLIT(E2,"-"),F2:H2))

 

[Data can be tough AP]

Modified screenshot to show column/rows:
View attachment 113777

Thank you this worked perfectly!

 

[Data can be tough AP]

How about:

=IF(AND(ISBLANK(F2:H2)),E2,TEXTJOIN("-",,IF(ISBLANK(F2:H2)=FALSE,F2:H2,TEXTSPLIT(E2,"-"))))

This worked perfectly!