My god, I was just using a reference table on another sheet to drive a few columns of data in my first sheet (basically a color hex code in the main sheet that would match a code in the reference table and return the color name in one column and a part size in the next one) and for some unknown reason, 3 rows of the reference table were causing an N/A (value not found) error in the first sheet.

I checked every variable I could think of and nothing was solving the issue.

Finally tried literally retyping the same damn value in the cell and it instantly fixed the issue. There weren't any extra spaces, format never changed...it just really needed me to retype it.