You have no matches - simple as.
Check that numbers are numbers and that you are not trying to compare a number with text, same with dates, check for leading and trailing spaces.
Or you have the array and criteria wrong in the VLOOKUP.
Beyond this, without seeing the data, no idea.
By the way, there really wasn't any need to start this new thread - next time, keep questions on what are essentially the same issue in the same place.
Bookmarks