Hi All,

Hope you can help. I am looking for formular that will type some text into a cell, depending on what is written in 2 other cells on a different sheet. so for example.

If on Sheet 3 Cell A2 the cell contains the words "Standard Perils" and on Sheet 3 Cell B2 the cell contains the words "Not Covered" then on sheet 1 Cell W2 i want it to input the words ""Standard Buildings".

Is this possible?

Thanks in advance.
Nick