Index/Match providing result with no match

Autumn Bennett

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))

Autumn Bennett

NVM, found my issue, I had a blank event ID in my other sheet with a producer assignment, so it was matching all the blanks to that