filter between two 365 workbooks on onedrive

I have two workbooks located in my one drive account. I am trying to do a simple filter function between the two but am getting the #N/A error. I have checked the path, and made sure that the both of the filter conditions are of the same format but I can not get it to work.
I am attempting to create the filter function on tab 8/2/2023 in the ETC template document.