• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Find - Option - Look in Formula vs Value How to express in Match Formula

391412

New Member
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?
 
Hi, 391412!


First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.


As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).


Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.


Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


And about your question...


Consider uploading a sample file (including manual examples of desired output), it'd be very useful for those who read this and might be able to help you. Thank you. Give a look at the second green sticky post at this forums main page for uploading guidelines.


Regards!
 
Back
Top