How to check if a certain text is in a cell and then return a a value based on that.

**giantmidget41** · 04-04-2019, 10:59 PM

Sorry for the confusing title. Basically what I am trying to do is write a formula that checks to see if certain characters are in a cell like: the "NY" in "12.HCGS.453423..NY"

And if there is an "NY" in that cell then return a certain value specific for "NY"

So I think I would need a list of the things that I want returned based on a specific search such as:

If the search finds "NY" then return "NYC"
If the search finds "OK" then return "OKC"

I am sorry if this is super confusing, I am trying to word it the best that I can. Let me know if I can help explain further and thank you for your help.

**FDibbins** · 04-04-2019, 11:35 PM

Hi, welcome to the forum

Well, depending on how many different strings you would be searching for, you could use something like...
=IF(ISNUMBER(SEARCH("ny",Q27)),"do this", "do that")

How to check if a certain text is in a cell and then return a a value based on that.

LinkBack

Thread Tools

Rate This Thread

Display

How to check if a certain text is in a cell and then return a a value based on that.

Re: How to check if a certain text is in a cell and then return a a value based on that.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Check a column for text, then return corresponding cell's value

[SOLVED] Check cell for text and return corresponding txt in adjacent cell

[SOLVED] Check to see if a cell contains text from a list then return the corresponding text

Check the text in two columns and then return the corresponding cell in column 3

Check if cell range has value and return text

Check if a cell contains text and return a embedded value

Check Cell for any text and return a value

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions