Get contents of cell if matches a string [Closed]

Report
-
 qtrmile69 -
Hello,

I am looking to populate a cell with the contents of another cell in that row if the contents of that cell contain any or part of a word.

example...

I want to populate cell A2 with the contents of any of the cells in that row if one of those cells contains the *RBSID*.

Note RBSID formats look like (( 101U2435 RBSID 23459 )) and there can be hundreds of different RBSID's

2 replies

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Try this
=IF(SUM(IF(ISERROR(FIND("RBSID",H25:H31)),0,FIND("RBSID",H25:H31)))>0,CELLADDRESSTOCOPY,"")
Enter the formula by using CTRL + SHIFT+ENTER

H25:H31 - data to lookup
Close.... I have a sample file i can send, and you can see where i need to fill data..

Column F in my sheet i need to fill with RBSID's from columns K thru !!!!

If you have an address to send this test file...it may help ..!!

Please send me an email to qtrmile69@hotmail.com