Formular to type text into a cell depending on data in 2 other cells

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

Hi Fortis,

That's fantastic and has worked, thank you so much. Now however just to be annoying i need to go a bit further.

Could i extend the formular to Type into my cell a different word, if the text in Cells A2 and B2 of sheet 3 are different, 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" OR If on Sheet 3 Cell A2 the cell contains the words "Standard Perils" and on Sheet 3 Cell B2 the cell contains the words "Standard Perils" then on sheet 1 Cell W2 i want it to input the words ""Standard Buildings and Standard Contents"?

Really appreciate your help, thank you soooo much!!!

That Sir, is amazing!

I have followed that and it has worked.

if i wanted to add to it (There are potentially 8 different combinations i need), do i just copy and past from the start of the second "IF" to the " and the end of 'Standard Contents' and replace the words with the different words? E.g. below:-

=IF(AND(Sheet3!A2="Standard Perils",Sheet3!B2="Not Covered"),"StandardBuildings",IF(AND(Sheet3!A2="Standard Perils",Sheet3!B2="Standard Perils"),"Standard Buildings and Standard Contents"IF(AND(Sheet3!A2="Standard Perils",Sheet3!B2="Accidental Damage"),"Standard Buildings and Contents with AD"IF(AND(Sheet3!A2="Not Covered",Sheet3!B2="Standard Perils"),"Standard Contents",""))

And so on?

Thanks again.

Hi,

That's fine, i will have a look at what INDEX&MATCH table is!

Sorry, as you may have guessed i am a novice on excel and need to work on a project!

Thanks a lot.