Ask a question Report Reply to this topic

Closed]

Cathy - Feb 19, 2016 at 05:32 PM - Latest reply: Ann

- Feb 22, 2016 at 04:43 PM

Excel Ask a question Report Reply to this topic

Hello,

Let us say I have 3 columns, column A is home email, column B is work email, and column C is other email. On column D, I want to return the value of column B if data is available, if data is not available, then I want to see if there is data in column C, if there is data in column C then I want to return that value in column D, if there is no data in column C then I want to look for data in column A. If there is data in column A then I want to return that value in column D, if there is no data in column A then column D can return the value of None.

Hope someone can help me w/figuring out the correct formula.

Thank you.

2 replies

Report Respond to RayH

RayH - Feb 19, 2016 at 09:23 PM

Helpful

You need what is called a "Nested If" to do this:

=IF(B2<>"",B2,IF(C2<>"",C2,IF(A2<>"",A2,"None")))

Report

Ann - Feb 22, 2016 at 04:43 PM

Thanks so much Ryan. It worked and saved me hours of doing it manually. I had 54k rows. yikes.

Have a good week.

Ask a question