• 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


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

Match formula question


New Member

I need some Match formula help. I'm currently using the formula =MATCH(a2,c:c,FALSE) to compare data and instead of #N/A in the cell I want it to enter a symbol. Is this possible? I've tried to search online and I'm not finding exactly what I'm wanting.

Thanks in advance for any and all help!

try using iferror()

what the symbol do you want

what version of excel do you want to use in ?

use char() and a list of symbols here

for example

and will display the symbol for char 131 if an error - like e4 has text in
Be very careful with the IFERROR function as it hides ALL errors, which might not be what you want sometimes hiding hiccups in your data.
IMO the IFNA function would be more appropriate here