If statement

[chally3]

Good morning all,

I have a complete brain freeze over my problem outlined below and would very much appreciate any help as I will have several spreadsheets I will need to do something very similar with. I am not sure how to write an if statement to look if a cells contains certain text.

In Column E I have a list of numbers that all end in either V01,V02 or V03
In Column G I have a list of country codes for example GB,USA,NL etc etc

What I am trying to do is in Column H is a simple comment of country check ok based on the following criteria.

IF Column E contains V01 in the text and Column G has 'GB' , add the comment 'Country check GB',IF Column E contains V03 in the text and Column G has USA' , add the comment 'Country check USA',otherwise return 'check region'

Thank you kindly as ever

Kind regards
Mark

 

[Peter_SSs]

If this is not it please give more detail/examples.

Excel Workbook
	E	F	G	H
2	123V01		GB	Country check GB
3	456V02		USA	Check region
4	123V01		NL	Check region
5	98765V03		USA	Country check USA
IF

 

[etaf]

IF Column E contains V01 in the text and Column G has 'GB' , add the comment 'Country check GB',IF Column E contains V03 in the text and Column G has USA' , add the comment 'Country check USA',otherwise return 'check region'

=IF( AND( right(E2,3)="V01", G2="GB") , "Country check GB", IF ( AND( right(E2,3)="V03", G2="USA") , "Country check USA", "check region"))

 

[chally3]

Absolutely perfect, thank you for your help and tuition

 

[Peter_SSs]

Absolutely perfect, thank you for your help and tuition

You are very welcome.