Another Formula not working

BrendonL

Hi again,

Im having an issue where im doing an index match on 2 columns across 2 sheets. I have double check the email that the index match is matching to and from. I am not sure why the index match is only picking up 2 rows and not values from all of the rows.

I've tried doing manually putting in the email in the blank row, but it still is empty and I've copied and pasted the emails to make sure they were the same across sheets but still same error.

heyjay

Add zero after Range 3}

=index({VSB Range 1},match([Volunteer…],{VSB Topics…},0))