Related:
- Get contents of cell if matches a string
- Call of duty: black ops – zombies downloadable content - Download - Shooters
- Clear only the formatting from the selected cell (leaving the content) - Guide
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Facebook Forum
- If cell contains date then return value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
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