Question: can i use iferror with index match?
Answer: Using INDEX MATCH with IFNA / IFERROR If you'd like to catch all errors, not only #N/A, use the IFERROR function instead of IFNA: =IFERROR(INDEX(C2:C10, MATCH(F1,A2:A10,0)), "Oops, something went wrong!")