Get contents of cell if matches a string

Closed
qtrmile - Oct 9, 2009 at 08:32 AM
 qtrmile69 - Oct 12, 2009 at 10:06 AM
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 responses

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Oct 12, 2009 at 07:57 AM
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
0
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
0