Hello, A beginner here so be gentle!
In my spreadsheet I need to see if a word appears in column B2 ("Corresp") and a "Y" in D2, If both appear I need "MO1698" to appear in F2. If only one appears there should be NO change. I can get them to show individually but when I try to combine them I get errors and can't sort it. Excel help suggests If/And combinations. Can anyone suggest something? Thanks in advance. David
In my spreadsheet I need to see if a word appears in column B2 ("Corresp") and a "Y" in D2, If both appear I need "MO1698" to appear in F2. If only one appears there should be NO change. I can get them to show individually but when I try to combine them I get errors and can't sort it. Excel help suggests If/And combinations. Can anyone suggest something? Thanks in advance. David