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

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

Find more posts tagged with

Formulas

Accepted answers

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))

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.