Is there a way that if VLOOKUP doesn't find a match that it can return the original value that was in the column? We use a file that we update information in. If we do not have an update, i do not want VLOOKUP replacing the data where there is no match. I want it to leave the last information. Please help there must be a way to have VLOOKUP, IGNORE cells where it does not find a match.