Fill Text Based on Text in Another Cell

[Nyagoslav]

Hi guys,

I hope I could get some guidance on the following case:

- I have an Excel file with 2 spreadsheets - Sheet1 and Sheet2

- Text in cell Sheet1!A11 is ABC

- Text in cell Sheet2!B2 can be either of two possibilities:
That's (with an apostrophe)
They're (again with an apostrophe)

- If the text in Sheet2!B2 is That's --> cell Sheet2!D2 should be filled with the exact text in cell Sheet1!A11

- If the text in Sheet2!B2 is They're --> cell Sheet2!D2 should be left empty

Could you let me know how this could be achieved?

Thank you very much in advance.

[FDibbins]

Hi, welco,e to the forum

Maybe something like this?

=if(Sheet2!B2="That's",Sheet1!A11,"")