I found that I could match cells from another sheet but the cells with additional special characters does not work as expected.
My formula in C2 = IFERROR(VLOOKUP(A2,Sheet2!A:M,3,false),"No Match") It works properly until I hit cells with special characters.
Example: In Sheet 1
A B C
ABC XXX 0
ABC@ XXX **No Match**
In Sheet 2
M
ABC
ABC@
The formula will need to change for it to match cells in Sheet 2.
I need the results to reflect correctly in Sheet 1.