Index/Match providing result with no match

Options

Good Morning,


I am trying to use Index/Match to pull a contact from another sheet based off an event ID, the formula is giving me a result even when the row does not have an event id set yet? what am I missing?

=INDEX({Producer}, MATCH([EVENT ID]@row, {Event ID}, 0))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!