match a word in a cell and copy anoher cell in the same row

L

Lise

Hi - sorry another question from me today!

Is there a formula or way to achieve the following please

I want to search through a column (say column B) containing both words and
numbers to see if any cell in that column contains a specific word if it does
I want the corresponding cell in column A (same row) to copy into a thirds
column.

Hope this makes sense
 
J

Jacob Skaria

The below formula would return value of ColA if the text in ColB contains the
word BK. Copy the formula to C1 and copy down as required

Col A Col B Col C
John BK1234 =IF(ISERROR(SEARCH("BK",B1)),"",A1)
Mary BK4563
Joe BK5356
Maria AB1234

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
If cell empty delete row 1
Finding row, then copy paste (macro) 5
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Finding Values in a cell 3
Need help creating a simple (?) SUM formula! 4
Sumproduct where cell values are the same in a sorted column 1
cell B1 contains a word listed in cell A1 2

Top