I have used index/match a lot in the last few months and have had next to zero issues. All of the sudden on one example I continue to get the #N/A error. I am using =INDEX('column I want return value from',MATCH('lookup value','column I want Excel to look through',0)). I know for a fact that the values exist because I have looked through them all. VLOOKUP is returning the same error. I have changed the formatting to general for the both sheets in their entirety. The sheets each have a theme if that has something to do with it. Any help would be much appreciated.

Thank you in advance!
Zach