VLOOKUP says #N/A, COUNTIF says the value is there: 18 look-alike pairs tested in a real Excel

You can see the customer number in both sheets. VLOOKUP returns #N/A. You wrap the value in TRIM, as...