caritx
New Member
- Joined
- Dec 1, 2009
- Messages
- 34
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!
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!