Forum Discussion
LauraJackson
May 05, 2023Copper 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!
- LauraJacksonCopper ContributorAmazing, thank you! I was overthinking it 🙂