Resolve Excel lookup errors caused by text-number mismatches or hidden whitespace using VALUE, TRIM, and Paste Special.