@Carys5 The NA error means that VLOOKUP does not find an exact match. The lookup values may be texts, numbers or a mix of them, but a match will only be found if the other table also contains the exact same text or number. For example: 10 = 10 and "name1" = "name1" and will be found as matching values. However, the number 10 does not equal " 10" (i.e. a 10 with a leading space). Likewise, "name1" does not equal "name1 " (note the trailing space!)
