Related:
- Get contents of cell if matches a string
- Excel count occurrences of string in cell - Guide
- Vba case string - Guide
- Excel if color cell - Guide
- Call of duty: black ops – zombies downloadable content - Download - Shooters
- Cell phone codes - Guide
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
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
=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