Forum Discussion

Jamie125's avatar
Jamie125
Copper Contributor
Jun 01, 2023
Solved

Copy one cells value if another cell has certain text.

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.           ...
excel
Formulas and Functions
Macros and VBA
  • OliverScheurich's avatar
    OliverScheurich
    Jun 01, 2023

    Jamie125 

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

    Maybe with this formula.

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jun 01, 2023

Jamie125 

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

Maybe with this formula.

 

  • Jamie125's avatar
    Jamie125
    Copper Contributor
    Jun 01, 2023
    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.

Resources