I am running a vlookup and for around 2500 values out of a total 8100 values I am getting #N/A error. The values for these do exist, so I am not sure what is causing the error. I used the trim function to remove any spaces. Please help. I am uploading the file with values. I am looking for the vlookup to return amount values from sheet 2 by looking at the vendor numbers. As you can see, almost 2500 amounts are not returned. Thanks.