If a cell contains specific text from a row return text

**Gmarinov** · 02-21-2017, 10:44 AM

Hello guys,

I just joined and I am very keen to get to know you.

I have a slight problem with finding the right formula. Please help me if you can:

I have a spreadsheet with a list of countries in column "B". I want to separate them by different tiers e.g. if column B equals to let's say UK, Turkey, Macedonia, Bulgaria to have a text "priority" in column C and also if i have Portugal, Greece and Spain in column "B" to have a text "comm" and if i have a county which does not match the ones that i listed to have "all others"?

Many thanks in advance!

George

**davesexcel** · 02-21-2017, 10:50 AM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

If a cell contains specific text from a row return text

LinkBack

Thread Tools

Rate This Thread

Display

If a cell contains specific text from a row return text

Re: If a cell contains specific text from a row return text

Thread Information

Users Browsing this Thread

Similar Threads

If two cells contain specific text, return text from third cell.

specific text in a cell should return a text in another cell

[SOLVED] If cell A contains specific text and cell b contains specific text then return this value

[SOLVED] Return Cell Value if Contains Specific Text

[SOLVED] If cell contains specific text, return that text

[SOLVED] If a cell contains a specific text than return a value

[SOLVED] How to return a specific formula calculation if specific text is enterd in another cell

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions