I am trying to perform an INDEX MATCH function with text data. Basically, I am trying to match a text field in one table, with a text field in another table, to pull out its corresponding identity code. I keep getting an N/A error, when when I perform a MATCH function itself, but the text is clearly present in the lookup table.
Solved by D. S. in 19 mins