Match formula question

[TennaCVols]

Hi,

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!

~Tenna

 

[ETAF]

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

Huge List of Unicode Character Symbols

This page provides a set of tables for Unicode character symbols, including emojis, emoticons, arrows, music, sports, etc.

www.vertex42.com

for example
=IFERROR(E4+E5,CHAR(131))

and will display the symbol for char 131 if an error - like e4 has text in

 

[TennaCVols]

Awesome! That formula example and chart solved my issue. Thank you so much!!!!!!!!!

 

[ETAF]

you are very welcome

 

[pecoflyer]

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