SOLVED

Copy one cells value if another cell has certain text.

Copper Contributor

Hi all, this is my first post as I'm at a loss as to if this is possible and I'll do my best to explain.

I have lots of different text in a column which has a value in another column eg. 

               A                   B         C...

1   [ I have text here ][ £35 ][ £0.00]  "excuse the crudeness"

I would like to, if possible, copy cell B1 if cell A1 has the word "text" in it and paste it in cell E1 for example?

A little long winded I know and there's probably an easier way of asking but any help would be appreciated. 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Jamie125 

=IF(ISNUMBER(SEARCH("text",A1)),B1,"")

Maybe with this formula.

copy cell under condition.JPG 

Thank you Quadruple_Pawn, I'm not great on excel so took a little playing to suit what I'm doing but that's great thank you.
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@Jamie125 

=IF(ISNUMBER(SEARCH("text",A1)),B1,"")

Maybe with this formula.

copy cell under condition.JPG 

View solution in original post