Ive run into a minor issue. Im using an IFS formula to compare two cells. If they are identical, then "Y", if they are not "X". The formula works fine but the issue im running into is that one of the cells is drawing its data from a different cell using the "=" formula. Is there a way to get google sheets to recognize that cell as actual data that matches?

Here is link to the spreadsheet in question: