Possible to copy data to cell if only one of multiple columns contain information

Justin Nicholas

Greetings,

Is there a formula that can be used to copy the text from a range of columns only if there is information in that column?

For example, I have Columns [Name A], [Name B], [Name C]. Only one of these columns will be filled at the any time. If one of those columns has information, copy that information into Column D

Ryan Sides

When you say "range" do you mean an actual range or do you mean you want every row of Column D to look at the same row to get the info?

If the latter, then use a nested if statement and NOT IS BLANK for each. Like...

=if(not(isblank([Name A]@row)), [Name A]@row, if(not(isblank([Name B]@row)), [Name B]@row, [Name C]@row))

Ryan Sides

When you say "range" do you mean an actual range or do you mean you want every row of Column D to look at the same row to get the info?

If the latter, then use a nested if statement and NOT IS BLANK for each. Like...

=if(not(isblank([Name A]@row)), [Name A]@row, if(not(isblank([Name B]@row)), [Name B]@row, [Name C]@row))

Justin Nicholas

This is exactly what I was looking for!

Ryan Sides

Sweet! Enjoy