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
Here is a quick example of a sample formula of an Index/Match without IFNA and with IFNA