Hi,

If you are still getting #N/A on the INDEX MATCH array formula, you do not have exact matches for those rows. There may be leading or trailing spaces, for example.