Here's a simple guide on removing #N/A errors in Google Sheets and Excel.
Open your formula
Add the IFNA function to the beginning of the formula
Add relevant parenthesis
Done!
Here is a quick example of a sample formula of an Index/Match without IFNA and with IFNA
Without IFNA:
=INDEX(A1:A3,MATCH(B1,C1:C3,0))
With IFNA:
=IFNA(INDEX(A1:A3,MATCH(B1,C1:C3,0)))