SOLVED

# Assistance with If Then Else

Copper Contributor

# Assistance with If Then Else

Hi everyone,

I am fairly new to Excel formulas and could use your help.  Here is an example of my data I am working with:

 Owner 1 Owner 2 Owner 3 Owner 4 Owner 5 Owner 6 Owner 7 Lawrence Shari Bernard Kristen Gustavo Brooke Maitane

I would like to add a column H that formulates the Owner by checking for a value in A, B, C, D, E, F or G. It would look like this:

 Owner 1 Owner 2 Owner 3 Owner 4 Owner 5 Owner 6 Owner 7 Account Owner Lawrence Lawrence Shari Shari Bernard Bernard Kristen Kristen Gustavo Gustavo Brooke Brooke Maitane Maitane

There is only ever one name in each row (record).

Any thoughts on what this formula would look like?

If A2 has a value, populate that value. If it is blank, populate with the value in B2. If B2 is blank, populate with what is in C2, and so on.

Thanks!

2 Replies
best response confirmed by LauraJackson (Copper Contributor)
Solution

In H2:

=CONCAT(A2:G2)

Fill down.

# Re: Assistance with If Then Else

Amazing, thank you! I was overthinking it :)
1 best response

Accepted Solutions
best response confirmed by LauraJackson (Copper Contributor)
Solution

In H2:

=CONCAT(A2:G2)

Fill down.