IF function

[kate074]

Hello all,

Thank you for any advice. I am normally pretty good at working these things out but today I am defeated so I am hoping theres someone here way smarter than me on formulas =)

I have three columns of data;

A
B
C

Each have data in them although there are some blanks in B and C. What I want to accomplish is this.

- Create column D
- If the cell in column C is blank check column B
- If the cell in column B is blank, check column A
- If column A has text in it, paste this text into the corresponding cell in column D

So basically I want excel to check each column in the order listed above. As soon as it comes across a cell with text in it, I want to copy that text into the corresponding cell in column D.

I hope that makes sense =)

Thank you!

[kate074]

Just to clarify, if Excel finds text in column C before reaching B or B before reaching A, I want that text copied into the cell in column D.

[Cutter]

Hi kate074 - welcome to the forum.

Try

=IF(C1<>"",C1,IF(B1<>"",B1,A1))

assumes there will always be something in one of the 3 cells.

[martindwilson]

=lookup(rept("z",255),a1:c1) will also do it, assuming text