Find Text In one Cell, Add Different In Another Cell

Closed
samisam321 Posts 1 Registration date Saturday June 21, 2014 Status Member Last seen June 21, 2014 - Jun 21, 2014 at 11:07 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 22, 2014 at 11:35 AM
Please be aware, I don't have much hair on my head to begin with and really don't have much to pull out either.. I'm frustrated.

I've tried every formula i could find on the web and couldn't get the right answer. What i'm trying to do is look at a specific column, search for a text (hope we can search without being case sensitive) and 2 columns next to it, I'd like to add specific text.

cell d3: LIGHTNING CHARGER CABLE FOR IPHONE 5/5S/IPAD/IPOD TRANSFER DATA & SYNCHRONIZATION

would like to search that cell for "iphone" as an example, and if the value does exist, i'd like to populate f5 with Apple

Can someone please suggest a solution.. this is killing me. I'm losing sleep over this.

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jun 22, 2014 at 11:35 AM
samisam321, Good morning.

Try to use:
F5 --> =IF(ISERROR(SEARCH("iphone",D3)),"","Apple")

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0