Index Match Else


Greeting All,

I have created a simple index match that successfully matches state/province from my reference datasheet to pull in the corresponding district.

I would love to indicate "N/A" for the instances when a state is blank but I cannot figure out the argument.

=INDEX({District}, MATCH([State/Prov]@row, {Reference Datasheet State/Prov}, 0))

Thank you in advance for any help.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!