Re: vlookup #n/a error when values exist
Thank you NBVC. This worked. Have a good day.
Posts by ANku86
-
-
Re: vlookup #n/a error when values exist
Thank you KjBox. This worked. Have a good day.
-
Hello,
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.
Regards,
AK