Vlookup Formula does not return value

On the current tab, the number in B4 has one space at the end, so the that cell doesn't really match what's in Previous.

ahh,

Thank you darkyam, I missed that entirely. I really do appreciate you pointing that out to me, now I can adjust around it. I have seen threads that relate to that.

darkyam, keep it up, I am sure that many people here appreciate your help as well as the others that volunteer their time as well.

Have a wonderful day.
David

You're very welcome. Thanks for the feedback.

Okay, I was playing with it some more and, it worked the first time but then it didn't.
..It still does the same thing, I even used the format painter to double check this. And as it goes in the future, it may become a problem... so unless there is something that I am missing.
..What happens is, that when the number is, let's say, retyped, then the formula will then return a #N/A value. As it stands, the numbers are set in General format, nothing has been updated, when the numbers are set up to be pasted into the spreadsheet.

I noticed this.
From the regular pasting, the numbers in column B will have the Horizontal alignment to the left, when the number is retyped, it will move to the right. Viewing the Format settings, it is still General in all respects of the cell formatting. There was nothing different with the exception of it being pasted by macro and then retyped by hand. The icons for the Left and Right alignment is not affected either, showing that everything is still General.

Keep in mind, that the spreadsheet is still to be user friendly with everything capable of editing by the user.

Hope that makes sense, and sorry about bringing the thread back up to the top again, especially when I thought it was solved. Which at first glance, it was, but now it's not.

Thanks,
David

I didn't want to bump this thread, but it happened to me again on this error. I use a macro to load the spreadsheets (macro in seperate workbook) and all but one works.
I have one that will give me the #N/A error. And when I retype the cell in the range to be looked up, it will work properly.

I was wondering if there is something that I can have that will keep all formatting the same? As mentioned by darkyam, there was a space in the cell contents, which is not viewable by the eye. And when you look for it, it really isn't there either.

Thanks for any assistance on this.
sorry about the bumping, but I need to figure this out.

the sample that I had provided in the original post is still valid for this request.

David

I had to find the answer to this thread, so I went to Oz for help on it.

I was given a solution there.
Thanks for the help here, it did point me a direction, I just couldn't see it.

See thread here.

Thank you,
David

Sorry, David, I totally missed your responses. I'm glad you got it all straightened out and thanks for posting a link to your solution.

darkyam

it's alright, I know that it is hard to keep up with the number of people in these forums. We try where we can. I have seen your responses in a number of threads from here and others, I do enjoy reading the ones that I have seen, so I know you are one of the good guys (not that there is any bad ones).

have a great day,
David