Formula Question

[caritx]

I have the following data in Columns A and B and I want C to be my formula.

Column A------- Column B
4152 -------------Y
(blank) ------------N
1524 --------------N
(blank)------------- Y

(-------------)just to show column separation

I want my formula to first look at column A and if there is a value bring that data over. If not look at column B and if there is a Y bring over "text1" if there is an N bring over "Text2".

I thought this would be a simple nested IF but I don't know how to tell it to just bring over the value in the cell. Column A might all be the same or be different. Thanks in advance I really appreciate any help you can give!

 

[Jonmo1]

Try

=IF(A2<>"",A2,IF(B2="Y","Text1","Text2"))

 

[caritx]

Thank you so much! Beyond awesome!