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

Copy addition formula of non-consecutive horizontal cells 2
Autonumber field in Excel that behaves the same as Access 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Search cell value in same column 3
Format column widths from one table to a separate table on same page 1
Adding a big matrix in Word 2013 5
Help with Sumproduct searching cell contents 2
How to hide rows having a specific value in cell of column A ? 0

Top