Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Counting cells containing only numbers
jutulu -
jutulu -

4 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses