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
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- 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 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
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