vlookup work great, but what if I want to type in a name and address without validation? If I type in a address I lose my formula. Is it possible to type in a address, I can type it in now but can't clear all the boxes and lose my formula.