Chandoo - I am parsing a cell in column CF, each cell has 1 to 30+ concatenated email addesses in it. Each survey is a row(1:20000) / Column C is each users *email@xxx.com*. The function I am using is MATCH($C14,SURVEYDATA!$CF$1:$CF$20000,0) and it returns the row number perfectly. But there are cells with data the Match does not see. In doing some problem determination with the simple Ctrl F, find does not find it either but Excel Find - Option - Look in - Change from Formula to Values does find it. The text email addresses plan text - How do I express this difference (Find Lookin formula to value) in a Match Function?