Get contents of cell if matches a string [Closed]

 qtrmile69 -

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.


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

Registration date
Saturday April 11, 2009
Last seen
June 21, 2011
Try this
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 may help ..!!

Please send me an email to